PREVIEW / etf_30min / 2009-06-05

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-06-05.parquet
  size:    223 KB
  rows:    7,421

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
2009-06-05 04:00:00	SPY	ETF	94.99	94.99	94.99	94.99	700.0
2009-06-05 04:30:00	SPY	ETF	94.86	94.86	94.79	94.79	600.0
2009-06-05 05:00:00	SPY	ETF	94.78	94.78	94.75	94.75	1570.0
2009-06-05 05:30:00	SPY	ETF	94.95	94.95	94.94	94.95	1800.0
2009-06-05 06:00:00	SPY	ETF	94.93	94.96	94.81	94.85	30600.0
2009-06-05 06:30:00	SPY	ETF	94.88	94.98	94.8	94.93	27300.0
2009-06-05 07:00:00	SPY	ETF	94.92	95.03	94.92	94.96	99238.0
2009-06-05 07:30:00	SPY	ETF	94.91	95.15	94.9	95.04	442844.0
2009-06-05 08:00:00	SPY	ETF	95.03	95.14	94.45	95.03	2213294.0
2009-06-05 08:30:00	SPY	ETF	95.03	96.2	94.6	95.65	17321328.0
2009-06-05 09:00:00	SPY	ETF	95.66	95.99	95.43	95.49	4575916.0
2009-06-05 09:30:00	SPY	ETF	95.49	95.67	94.42	94.67	45284068.0
2009-06-05 10:00:00	SPY	ETF	94.67	95.61	93.8	94.34	37702772.0
2009-06-05 10:30:00	SPY	ETF	94.3386	94.93	94.17	94.85	27898495.0
2009-06-05 11:00:00	SPY	ETF	94.84	95.16	94.8	94.83	16636724.0
2009-06-05 11:30:00	SPY	ETF	94.83	94.92	94.55	94.88	11273862.0
2009-06-05 12:00:00	SPY	ETF	94.88	95.03	94.66	94.98	10115550.0
2009-06-05 12:30:00	SPY	ETF	94.99	95.07	94.88	95.02	7768389.0
2009-06-05 13:00:00	SPY	ETF	95.02	95.03	94.635	94.71	7778745.0
2009-06-05 13:30:00	SPY	ETF	94.71	94.89	94.54	94.65	8159649.0
2009-06-05 14:00:00	SPY	ETF	94.64	94.71	93.99	94.16	16457385.0
2009-06-05 14:30:00	SPY	ETF	94.16	94.45	93.94	94.35	16942424.0
2009-06-05 15:00:00	SPY	ETF	94.34	94.56	94.19	94.28	14530034.0
2009-06-05 15:30:00	SPY	ETF	94.28	94.79	94.25	94.53	24154013.0
2009-06-05 16:00:00	SPY	ETF	94.54	95.35	93.9	94.4	9234616.0
2009-06-05 16:30:00	SPY	ETF	94.44	94.44	94.37	94.38	43707.0
2009-06-05 17:00:00	SPY	ETF	94.38	94.6549	94.33	94.38	1041134.0
2009-06-05 17:30:00	SPY	ETF	94.38	94.51	94.36	94.42	29044.0
2009-06-05 18:00:00	SPY	ETF	94.45	94.46	94.33	94.39	9977.0
2009-06-05 18:30:00	SPY	ETF	94.38	94.46	94.38	94.45	4080.0
2009-06-05 19:00:00	SPY	ETF	94.44	94.44	94.36	94.4	8803.0
2009-06-05 19:30:00	SPY	ETF	94.4	94.46	94.4	94.41	16974.0
2009-06-05 04:00:00	QQQ	ETF	36.85	36.85	36.85	36.85	500.0
2009-06-05 06:30:00	QQQ	ETF	36.85	36.85	36.85	36.85	200.0
2009-06-05 07:00:00	QQQ	ETF	36.83	36.92	36.83	36.87	115899.0
2009-06-05 07:30:00	QQQ	ETF	36.88	36.92	36.86	36.88	77410.0
2009-06-05 08:00:00	QQQ	ETF	36.88	36.91	36.84	36.89	261056.0
2009-06-05 08:30:00	QQQ	ETF	36.89	37.22	36.89	37.05	4730801.0
2009-06-05 09:00:00	QQQ	ETF	37.05	37.15	36.95	36.97	1207200.0
2009-06-05 09:30:00	QQQ	ETF	36.96	37.08	36.56	36.69	25328966.0
2009-06-05 10:00:00	QQQ	ETF	36.7	36.7657	36.42	36.58	15126303.0
2009-06-05 10:30:00	QQQ	ETF	36.58	36.8101	36.53	36.74	10799937.0
2009-06-05 11:00:00	QQQ	ETF	36.74	36.88	36.72	36.77	6285783.0
2009-06-05 11:30:00	QQQ	ETF	36.77	36.79	36.63	36.7695	3612807.0
2009-06-05 12:00:00	QQQ	ETF	36.77	36.91	36.71	36.89	6079664.0
2009-06-05 12:30:00	QQQ	ETF	36.88	36.91	36.84	36.89	2794238.0
2009-06-05 13:00:00	QQQ	ETF	36.88	36.89	36.76	36.78	3726982.0
2009-06-05 13:30:00	QQQ	ETF	36.79	36.86	36.7405	36.77	3317242.0
2009-06-05 14:00:00	QQQ	ETF	36.77	36.78	36.51	36.57	7098097.0
2009-06-05 14:30:00	QQQ	ETF	36.58	36.68	36.5	36.64	4270107.0

> showing 50 of 7,421 rows — these rows as CSV

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