PREVIEW / etf_30min / 2010-06-10

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-06-10.parquet
  size:    257 KB
  rows:    8,543

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
2010-06-10 04:00:00	SPY	ETF	106.59	106.84	106.59	106.84	1910.0
2010-06-10 04:30:00	SPY	ETF	106.83	107.34	106.83	107.14	8080.0
2010-06-10 05:00:00	SPY	ETF	107.18	107.47	107.18	107.35	53800.0
2010-06-10 05:30:00	SPY	ETF	107.33	107.33	107.27	107.3	11100.0
2010-06-10 06:00:00	SPY	ETF	107.13	107.21	107.04	107.19	42300.0
2010-06-10 06:30:00	SPY	ETF	107.2	107.29	107.14	107.25	41030.0
2010-06-10 07:00:00	SPY	ETF	107.24	107.35	107.07	107.1	491140.0
2010-06-10 07:30:00	SPY	ETF	107.07	107.2	106.97	106.97	333941.0
2010-06-10 08:00:00	SPY	ETF	106.99	107.33	106.91	107.15	1284935.0
2010-06-10 08:30:00	SPY	ETF	107.09	107.31	106.77	107.21	4418547.0
2010-06-10 09:00:00	SPY	ETF	107.21	107.9	107.11	107.86	4492374.0
2010-06-10 09:30:00	SPY	ETF	107.86	108.62	107.73	108.58	42577622.0
2010-06-10 10:00:00	SPY	ETF	108.58	108.83	108.0	108.18	33399143.0
2010-06-10 10:30:00	SPY	ETF	108.18	108.42	108.1625	108.28	17146272.0
2010-06-10 11:00:00	SPY	ETF	108.28	108.6	108.28	108.44	12399450.0
2010-06-10 11:30:00	SPY	ETF	108.44	108.51	108.07	108.28	16060724.0
2010-06-10 12:00:00	SPY	ETF	108.28	108.33	107.8	108.18	15885176.0
2010-06-10 12:30:00	SPY	ETF	108.18	108.33	107.69	108.02	13597785.0
2010-06-10 13:00:00	SPY	ETF	108.02	108.21	107.7396	108.1295	9059487.0
2010-06-10 13:30:00	SPY	ETF	108.13	108.48	108.12	108.33	9741053.0
2010-06-10 14:00:00	SPY	ETF	108.33	108.47	108.02	108.38	12130552.0
2010-06-10 14:30:00	SPY	ETF	108.38	108.87	108.37	108.665	17116276.0
2010-06-10 15:00:00	SPY	ETF	108.6686	109.17	108.56	108.9893	25741810.0
2010-06-10 15:30:00	SPY	ETF	108.98	109.28	108.77	109.19	40383046.0
2010-06-10 16:00:00	SPY	ETF	109.18	109.19	107.78	108.97	13856064.0
2010-06-10 16:30:00	SPY	ETF	108.95	109.19	108.81	109.0	22450484.0
2010-06-10 17:00:00	SPY	ETF	109.01	109.08	108.99	109.08	70268.0
2010-06-10 17:30:00	SPY	ETF	109.05	109.08	108.96	109.04	68595.0
2010-06-10 18:00:00	SPY	ETF	109.05	109.19	109.0	109.0	69105.0
2010-06-10 18:30:00	SPY	ETF	109.01	109.01	108.92	108.96	60894.0
2010-06-10 19:00:00	SPY	ETF	108.96	108.98	108.91	108.98	30550.0
2010-06-10 19:30:00	SPY	ETF	108.98	108.99	108.91	108.99	35640.0
2010-06-10 04:00:00	QQQ	ETF	43.94	43.94	43.94	43.94	100.0
2010-06-10 04:30:00	QQQ	ETF	44.16	44.29	44.16	44.29	1278.0
2010-06-10 05:00:00	QQQ	ETF	44.26	44.26	44.26	44.26	2000.0
2010-06-10 05:30:00	QQQ	ETF	44.36	44.36	44.33	44.33	300.0
2010-06-10 06:00:00	QQQ	ETF	44.29	44.29	44.25	44.27	852.0
2010-06-10 06:30:00	QQQ	ETF	44.26	44.31	44.26	44.28	8752.0
2010-06-10 07:00:00	QQQ	ETF	44.27	44.36	44.23	44.25	108054.0
2010-06-10 07:30:00	QQQ	ETF	44.24	44.24	44.13	44.15	170195.0
2010-06-10 08:00:00	QQQ	ETF	44.16	44.26	44.13	44.22	299104.0
2010-06-10 08:30:00	QQQ	ETF	44.2	44.28	44.0	44.19	1242985.0
2010-06-10 09:00:00	QQQ	ETF	44.19	44.42	44.15	44.4	1567212.0
2010-06-10 09:30:00	QQQ	ETF	44.4	44.72	44.24	44.68	12916996.0
2010-06-10 10:00:00	QQQ	ETF	44.68	44.81	44.5	44.6	7070754.0
2010-06-10 10:30:00	QQQ	ETF	44.6	44.74	44.59	44.66	4423317.0
2010-06-10 11:00:00	QQQ	ETF	44.66	44.7902	44.65	44.69	3050862.0
2010-06-10 11:30:00	QQQ	ETF	44.68	44.71	44.49	44.63	3879737.0
2010-06-10 12:00:00	QQQ	ETF	44.63	44.65	44.46	44.59	4363212.0
2010-06-10 12:30:00	QQQ	ETF	44.59	44.66	44.38	44.5	3058298.0

> showing 50 of 8,543 rows — these rows as CSV

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