PREVIEW / etf_30min / 2017-05-10

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-05-10.parquet
  size:    426 KB
  rows:    14,613

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2017-05-10 04:00:00	SPY	ETF	239.02	239.02	239.0	239.0	2821.0
2017-05-10 04:30:00	SPY	ETF	239.05	239.08	239.05	239.08	1500.0
2017-05-10 05:00:00	SPY	ETF	239.08	239.14	239.03	239.14	3403.0
2017-05-10 05:30:00	SPY	ETF	239.07	239.11	239.05	239.11	1013.0
2017-05-10 06:00:00	SPY	ETF	239.13	239.17	239.13	239.14	3034.0
2017-05-10 06:30:00	SPY	ETF	239.12	239.12	239.05	239.05	10851.0
2017-05-10 07:00:00	SPY	ETF	239.12	239.17	239.05	239.17	42641.0
2017-05-10 07:30:00	SPY	ETF	239.2	239.31	239.18	239.28	162825.0
2017-05-10 08:00:00	SPY	ETF	239.26	239.39	239.08	239.36	88492.0
2017-05-10 08:30:00	SPY	ETF	239.36	239.43	239.33	239.33	176004.0
2017-05-10 09:00:00	SPY	ETF	239.33	239.38	239.24	239.38	1988034.0
2017-05-10 09:30:00	SPY	ETF	239.39	239.48	239.2	239.41	5189602.0
2017-05-10 10:00:00	SPY	ETF	239.41	239.53	239.15	239.19	4000883.0
2017-05-10 10:30:00	SPY	ETF	239.2	239.51	239.17	239.3999	3555637.0
2017-05-10 11:00:00	SPY	ETF	239.41	239.7771	239.37	239.725	3720203.0
2017-05-10 11:30:00	SPY	ETF	239.7273	239.75	239.62	239.65	3220445.0
2017-05-10 12:00:00	SPY	ETF	239.659	239.74	239.62	239.66	2708495.0
2017-05-10 12:30:00	SPY	ETF	239.66	239.76	239.63	239.76	3279798.0
2017-05-10 13:00:00	SPY	ETF	239.76	239.85	239.66	239.76	1715690.0
2017-05-10 13:30:00	SPY	ETF	239.76	239.81	239.67	239.72	2515172.0
2017-05-10 14:00:00	SPY	ETF	239.72	239.765	239.57	239.59	1707754.0
2017-05-10 14:30:00	SPY	ETF	239.58	239.8	239.58	239.75	1524604.0
2017-05-10 15:00:00	SPY	ETF	239.75	239.86	239.69	239.69	4583548.0
2017-05-10 15:30:00	SPY	ETF	239.7	239.87	239.581	239.85	8022528.0
2017-05-10 16:00:00	SPY	ETF	239.85	239.89	239.67	239.69	3599008.0
2017-05-10 16:30:00	SPY	ETF	239.7	239.79	239.5963	239.7	477201.0
2017-05-10 17:00:00	SPY	ETF	239.7	239.87	239.62	239.7	559612.0
2017-05-10 17:30:00	SPY	ETF	239.7	239.72	239.68	239.7	24724.0
2017-05-10 18:00:00	SPY	ETF	239.69	239.867	239.69	239.7	32934.0
2017-05-10 18:30:00	SPY	ETF	239.67	239.72	239.67	239.71	9487.0
2017-05-10 19:00:00	SPY	ETF	239.7	239.71	239.65	239.65	11354.0
2017-05-10 19:30:00	SPY	ETF	239.7	239.75	239.69	239.75	11546.0
2017-05-10 04:00:00	QQQ	ETF	138.17	138.21	138.15	138.15	4243.0
2017-05-10 07:00:00	QQQ	ETF	138.27	138.32	138.27	138.32	8100.0
2017-05-10 07:30:00	QQQ	ETF	138.33	138.37	138.32	138.36	14568.0
2017-05-10 08:00:00	QQQ	ETF	138.34	138.38	138.34	138.35	15314.0
2017-05-10 08:30:00	QQQ	ETF	138.35	138.39	138.34	138.34	15660.0
2017-05-10 09:00:00	QQQ	ETF	138.33	138.41	138.32	138.4	70337.0
2017-05-10 09:30:00	QQQ	ETF	138.4	138.42	138.02	138.11	1782989.0
2017-05-10 10:00:00	QQQ	ETF	138.11	138.16	137.93	137.96	1498111.0
2017-05-10 10:30:00	QQQ	ETF	137.96	138.1053	137.91	137.955	1243389.0
2017-05-10 11:00:00	QQQ	ETF	137.96	138.3	137.94	138.255	941256.0
2017-05-10 11:30:00	QQQ	ETF	138.26	138.27	138.13	138.195	392829.0
2017-05-10 12:00:00	QQQ	ETF	138.195	138.28	138.155	138.26	372407.0
2017-05-10 12:30:00	QQQ	ETF	138.2551	138.36	138.23	138.3407	429410.0
2017-05-10 13:00:00	QQQ	ETF	138.3462	138.385	138.25	138.36	643376.0
2017-05-10 13:30:00	QQQ	ETF	138.37	138.41	138.33	138.38	430578.0
2017-05-10 14:00:00	QQQ	ETF	138.37	138.41	138.29	138.29	512036.0
2017-05-10 14:30:00	QQQ	ETF	138.29	138.4099	138.2884	138.37	644334.0
2017-05-10 15:00:00	QQQ	ETF	138.37	138.45	138.319	138.32	904662.0

> showing 50 of 14,613 rows — these rows as CSV

> unlock the full archive -- $79 one-time