PREVIEW / etf_30min / 2009-06-12

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-06-12.parquet
  size:    210 KB
  rows:    7,118

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-12 05:00:00	SPY	ETF	94.83	94.83	94.83	94.83	314.0
2009-06-12 05:30:00	SPY	ETF	94.59	94.6	94.57	94.57	3600.0
2009-06-12 06:00:00	SPY	ETF	94.56	94.66	94.56	94.63	30299.0
2009-06-12 06:30:00	SPY	ETF	94.68	94.71	94.56	94.71	19920.0
2009-06-12 07:00:00	SPY	ETF	94.67	94.67	94.33	94.33	164720.0
2009-06-12 07:30:00	SPY	ETF	94.33	94.46	94.22	94.45	329689.0
2009-06-12 08:00:00	SPY	ETF	94.65	94.65	94.21	94.26	1364459.0
2009-06-12 08:30:00	SPY	ETF	94.26	94.85	94.09	94.22	1519683.0
2009-06-12 09:00:00	SPY	ETF	94.22	94.4	94.1174	94.4	1087087.0
2009-06-12 09:30:00	SPY	ETF	94.4	94.52	94.12	94.21	23932193.0
2009-06-12 10:00:00	SPY	ETF	94.21	94.59	94.0	94.35	20640730.0
2009-06-12 10:30:00	SPY	ETF	94.34	94.8	94.29	94.62	16841893.0
2009-06-12 11:00:00	SPY	ETF	94.62	94.68	94.42	94.48	6810342.0
2009-06-12 11:30:00	SPY	ETF	94.49	94.6	94.29	94.38	7926433.0
2009-06-12 12:00:00	SPY	ETF	94.38	94.9521	94.37	94.46	5699554.0
2009-06-12 12:30:00	SPY	ETF	94.47	94.59	94.2926	94.55	11558646.0
2009-06-12 13:00:00	SPY	ETF	94.56	94.66	94.41	94.51	7606107.0
2009-06-12 13:30:00	SPY	ETF	94.51	94.74	94.45	94.6701	11275092.0
2009-06-12 14:00:00	SPY	ETF	94.6701	94.71	94.51	94.55	7292267.0
2009-06-12 14:30:00	SPY	ETF	94.56	95.13	94.555	94.93	19259237.0
2009-06-12 15:00:00	SPY	ETF	94.94	95.09	94.91	95.02	9829413.0
2009-06-12 15:30:00	SPY	ETF	95.02	95.13	94.6	95.11	22496955.0
2009-06-12 16:00:00	SPY	ETF	95.12	95.13	94.5977	95.01	6622437.0
2009-06-12 16:30:00	SPY	ETF	95.01	95.05	94.82	94.84	1291455.0
2009-06-12 17:00:00	SPY	ETF	94.83	94.95	94.81	94.9	71875.0
2009-06-12 17:30:00	SPY	ETF	94.9	94.98	94.9	94.98	6149.0
2009-06-12 18:00:00	SPY	ETF	94.96	94.96	94.9	94.95	10824.0
2009-06-12 18:30:00	SPY	ETF	94.94	94.98	94.91	94.95	3895.0
2009-06-12 19:00:00	SPY	ETF	94.94	94.94	94.88	94.88	2493.0
2009-06-12 19:30:00	SPY	ETF	94.93	94.98	94.91	94.91	4800.0
2009-06-12 04:30:00	QQQ	ETF	36.87	36.87	36.87	36.87	200.0
2009-06-12 05:00:00	QQQ	ETF	36.9	36.9	36.9	36.9	341.0
2009-06-12 05:30:00	QQQ	ETF	36.82	36.82	36.79	36.79	3100.0
2009-06-12 06:00:00	QQQ	ETF	36.82	36.83	36.79	36.79	87904.0
2009-06-12 06:30:00	QQQ	ETF	36.82	36.82	36.77	36.82	47691.0
2009-06-12 07:00:00	QQQ	ETF	36.82	36.82	36.67	36.67	125260.0
2009-06-12 07:30:00	QQQ	ETF	36.67	36.67	36.61	36.65	195872.0
2009-06-12 08:00:00	QQQ	ETF	36.66	36.79	36.59	36.6	670434.0
2009-06-12 08:30:00	QQQ	ETF	36.6	36.66	36.58	36.65	390170.0
2009-06-12 09:00:00	QQQ	ETF	36.65	36.67	36.62	36.67	676576.0
2009-06-12 09:30:00	QQQ	ETF	36.67	36.719	36.33	36.39	13441484.0
2009-06-12 10:00:00	QQQ	ETF	36.39	36.44	36.2	36.3	17294213.0
2009-06-12 10:30:00	QQQ	ETF	36.3	36.56	36.25	36.42	9961795.0
2009-06-12 11:00:00	QQQ	ETF	36.42	36.45	36.33	36.36	3809081.0
2009-06-12 11:30:00	QQQ	ETF	36.37	36.41	36.25	36.299	4195911.0
2009-06-12 12:00:00	QQQ	ETF	36.29	36.39	36.29	36.34	2075960.0
2009-06-12 12:30:00	QQQ	ETF	36.34	36.41	36.27	36.41	3131891.0
2009-06-12 13:00:00	QQQ	ETF	36.41	36.44	36.33	36.36	4998431.0
2009-06-12 13:30:00	QQQ	ETF	36.36	36.44	36.3	36.41	5385335.0
2009-06-12 14:00:00	QQQ	ETF	36.4	36.46	36.35	36.39	4650177.0

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

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