PREVIEW / etf_30min / 2017-06-08

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-06-08.parquet
  size:    429 KB
  rows:    14,700

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-06-08 04:00:00	SPY	ETF	243.7	243.76	243.68	243.76	10595.0
2017-06-08 04:30:00	SPY	ETF	243.78	243.81	243.76	243.76	1800.0
2017-06-08 05:00:00	SPY	ETF	243.81	243.92	243.81	243.86	7300.0
2017-06-08 05:30:00	SPY	ETF	243.86	243.88	243.83	243.83	4400.0
2017-06-08 06:00:00	SPY	ETF	243.87	243.95	243.83	243.94	9980.0
2017-06-08 06:30:00	SPY	ETF	243.96	244.08	243.96	244.03	105270.0
2017-06-08 07:00:00	SPY	ETF	244.03	244.07	243.92	243.95	210151.0
2017-06-08 07:30:00	SPY	ETF	243.96	244.0	243.85	243.87	91104.0
2017-06-08 08:00:00	SPY	ETF	243.95	244.07	243.8	243.87	99925.0
2017-06-08 08:30:00	SPY	ETF	243.86	243.88	243.74	243.76	178376.0
2017-06-08 09:00:00	SPY	ETF	243.79	243.87	243.75	243.78	227006.0
2017-06-08 09:30:00	SPY	ETF	243.77	244.02	243.3	243.57	4619163.0
2017-06-08 10:00:00	SPY	ETF	243.58	243.8	243.17	243.31	4695855.0
2017-06-08 10:30:00	SPY	ETF	243.3	243.69	243.28	243.5746	2962627.0
2017-06-08 11:00:00	SPY	ETF	243.57	243.9	243.57	243.7	4065390.0
2017-06-08 11:30:00	SPY	ETF	243.7	243.86	243.61	243.855	2668844.0
2017-06-08 12:00:00	SPY	ETF	243.85	244.33	243.84	244.09	5143995.0
2017-06-08 12:30:00	SPY	ETF	244.09	244.185	244.018	244.17	2721146.0
2017-06-08 13:00:00	SPY	ETF	244.175	244.19	243.63	243.71	4577658.0
2017-06-08 13:30:00	SPY	ETF	243.71	244.0	243.6937	243.985	2572952.0
2017-06-08 14:00:00	SPY	ETF	243.985	244.02	243.42	243.48	3118194.0
2017-06-08 14:30:00	SPY	ETF	243.48	243.6154	243.19	243.33	6921800.0
2017-06-08 15:00:00	SPY	ETF	243.33	243.66	243.32	243.63	5197280.0
2017-06-08 15:30:00	SPY	ETF	243.63	243.86	243.48	243.76	9220982.0
2017-06-08 16:00:00	SPY	ETF	243.77	243.78	243.6	243.69	4135571.0
2017-06-08 16:30:00	SPY	ETF	243.67	243.88	243.65	243.88	447426.0
2017-06-08 17:00:00	SPY	ETF	243.84	243.84	243.21	243.23	631604.0
2017-06-08 17:30:00	SPY	ETF	243.24	243.3	243.19	243.2	179874.0
2017-06-08 18:00:00	SPY	ETF	243.19	243.44	243.04	243.39	236504.0
2017-06-08 18:30:00	SPY	ETF	243.4	243.42	243.3	243.32	32567.0
2017-06-08 19:00:00	SPY	ETF	243.31	243.31	243.25	243.26	29578.0
2017-06-08 19:30:00	SPY	ETF	243.24	243.28	243.15	243.18	47268.0
2017-06-08 04:00:00	QQQ	ETF	143.5	143.5	143.5	143.5	100.0
2017-06-08 05:00:00	QQQ	ETF	143.57	143.57	143.57	143.57	100.0
2017-06-08 06:00:00	QQQ	ETF	143.59	143.59	143.59	143.59	175.0
2017-06-08 06:30:00	QQQ	ETF	143.67	143.74	143.67	143.72	1599.0
2017-06-08 07:00:00	QQQ	ETF	143.74	143.81	143.73	143.74	95448.0
2017-06-08 07:30:00	QQQ	ETF	143.75	143.82	143.71	143.72	53099.0
2017-06-08 08:00:00	QQQ	ETF	143.74	143.77	143.7	143.72	49425.0
2017-06-08 08:30:00	QQQ	ETF	143.77	143.83	143.72	143.74	30007.0
2017-06-08 09:00:00	QQQ	ETF	143.73	143.87	143.73	143.77	78532.0
2017-06-08 09:30:00	QQQ	ETF	143.74	143.8	142.97	143.14	3378276.0
2017-06-08 10:00:00	QQQ	ETF	143.155	143.28	142.79	142.94	3154425.0
2017-06-08 10:30:00	QQQ	ETF	142.93	143.3	142.93	143.22	1353569.0
2017-06-08 11:00:00	QQQ	ETF	143.23	143.49	143.23	143.3	1715109.0
2017-06-08 11:30:00	QQQ	ETF	143.3001	143.42	143.22	143.39	741166.0
2017-06-08 12:00:00	QQQ	ETF	143.39	143.54	143.34	143.36	1368715.0
2017-06-08 12:30:00	QQQ	ETF	143.36	143.43	143.3	143.4	795173.0
2017-06-08 13:00:00	QQQ	ETF	143.4	143.43	143.11	143.135	815964.0
2017-06-08 13:30:00	QQQ	ETF	143.135	143.3599	143.11	143.34	852589.0

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

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