PREVIEW / etf_30min / 2017-07-21

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-07-21.parquet
  size:    422 KB
  rows:    14,527

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-07-21 04:00:00	SPY	ETF	247.16	247.2	247.16	247.2	1504.0
2017-07-21 04:30:00	SPY	ETF	247.26	247.3	247.26	247.3	1300.0
2017-07-21 05:00:00	SPY	ETF	247.34	247.39	247.3	247.31	10104.0
2017-07-21 05:30:00	SPY	ETF	247.36	247.36	247.14	247.14	2730.0
2017-07-21 06:00:00	SPY	ETF	247.19	247.19	247.04	247.04	1629.0
2017-07-21 06:30:00	SPY	ETF	246.99	247.02	246.85	246.92	2570.0
2017-07-21 07:00:00	SPY	ETF	246.92	247.0	246.9	246.95	15270.0
2017-07-21 07:30:00	SPY	ETF	246.94	247.04	246.9	246.93	16207.0
2017-07-21 08:00:00	SPY	ETF	246.91	247.26	246.91	246.97	235373.0
2017-07-21 08:30:00	SPY	ETF	246.97	246.98	246.71	246.74	235578.0
2017-07-21 09:00:00	SPY	ETF	246.75	246.75	246.38	246.44	1672130.0
2017-07-21 09:30:00	SPY	ETF	246.44	246.65	246.23	246.33	8171639.0
2017-07-21 10:00:00	SPY	ETF	246.33	246.55	246.18	246.47	23114518.0
2017-07-21 10:30:00	SPY	ETF	246.47	246.52	246.2069	246.26	5821065.0
2017-07-21 11:00:00	SPY	ETF	246.26	246.53	246.24	246.4761	3607372.0
2017-07-21 11:30:00	SPY	ETF	246.47	246.71	246.445	246.71	4456513.0
2017-07-21 12:00:00	SPY	ETF	246.71	246.77	246.58	246.62	3537820.0
2017-07-21 12:30:00	SPY	ETF	246.615	246.8	246.59	246.77	2147830.0
2017-07-21 13:00:00	SPY	ETF	246.77	246.9	246.7324	246.78	3813210.0
2017-07-21 13:30:00	SPY	ETF	246.79	246.79	246.65	246.725	4616412.0
2017-07-21 14:00:00	SPY	ETF	246.725	246.74	246.55	246.6742	1977809.0
2017-07-21 14:30:00	SPY	ETF	246.68	246.77	246.67	246.68	2333349.0
2017-07-21 15:00:00	SPY	ETF	246.685	246.71	246.495	246.56	2151685.0
2017-07-21 15:30:00	SPY	ETF	246.56	246.91	246.55	246.89	8545917.0
2017-07-21 16:00:00	SPY	ETF	246.89	246.9017	246.78	246.82	5536671.0
2017-07-21 16:30:00	SPY	ETF	246.81	246.9006	246.76	246.88	2527778.0
2017-07-21 17:00:00	SPY	ETF	246.87	246.9	246.85	246.85	2246591.0
2017-07-21 17:30:00	SPY	ETF	246.85	246.85	246.81	246.85	20520.0
2017-07-21 18:00:00	SPY	ETF	246.85	246.88	246.82	246.82	2389.0
2017-07-21 18:30:00	SPY	ETF	246.83	246.9	246.83	246.86	10480.0
2017-07-21 19:00:00	SPY	ETF	246.87	246.91	246.85	246.85	4623.0
2017-07-21 19:30:00	SPY	ETF	246.89	246.89	246.8	246.81	9131.0
2017-07-21 05:00:00	QQQ	ETF	144.24	144.25	144.24	144.25	500.0
2017-07-21 05:30:00	QQQ	ETF	144.23	144.23	144.23	144.23	700.0
2017-07-21 06:00:00	QQQ	ETF	144.07	144.07	144.07	144.07	220.0
2017-07-21 06:30:00	QQQ	ETF	143.98	144.04	143.87	144.02	9750.0
2017-07-21 07:00:00	QQQ	ETF	143.99	144.0	143.99	144.0	12200.0
2017-07-21 07:30:00	QQQ	ETF	143.95	144.01	143.9	143.92	7285.0
2017-07-21 08:00:00	QQQ	ETF	143.91	144.02	143.76	143.86	201798.0
2017-07-21 08:30:00	QQQ	ETF	143.88	143.95	143.79	143.81	59266.0
2017-07-21 09:00:00	QQQ	ETF	143.8	143.8	143.44	143.58	343431.0
2017-07-21 09:30:00	QQQ	ETF	143.6	143.8673	143.35	143.72	5138574.0
2017-07-21 10:00:00	QQQ	ETF	143.72	143.93	143.6201	143.7175	3945600.0
2017-07-21 10:30:00	QQQ	ETF	143.715	143.87	143.62	143.67	1077997.0
2017-07-21 11:00:00	QQQ	ETF	143.67	143.77	143.51	143.76	891016.0
2017-07-21 11:30:00	QQQ	ETF	143.75	143.9	143.69	143.9	617444.0
2017-07-21 12:00:00	QQQ	ETF	143.9	143.96	143.83	143.9099	565944.0
2017-07-21 12:30:00	QQQ	ETF	143.91	144.049	143.9	144.03	499490.0
2017-07-21 13:00:00	QQQ	ETF	144.03	144.11	143.94	143.9569	919282.0
2017-07-21 13:30:00	QQQ	ETF	143.9699	143.98	143.83	143.93	760512.0

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

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