PREVIEW / etf_30min / 2009-08-17

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-08-17.parquet
  size:    233 KB
  rows:    7,911

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-08-17 04:00:00	SPY	ETF	99.14	99.2	98.76	99.2	14060.0
2009-08-17 04:30:00	SPY	ETF	99.32	99.32	98.89	98.89	5300.0
2009-08-17 05:00:00	SPY	ETF	99.02	99.02	98.8	98.8	54556.0
2009-08-17 05:30:00	SPY	ETF	98.81	99.09	98.74	99.09	22450.0
2009-08-17 06:00:00	SPY	ETF	99.16	99.19	98.96	98.96	39556.0
2009-08-17 06:30:00	SPY	ETF	98.95	99.05	98.78	98.82	41889.0
2009-08-17 07:00:00	SPY	ETF	98.84	98.93	98.54	98.89	486488.0
2009-08-17 07:30:00	SPY	ETF	98.89	98.92	98.61	98.67	1335551.0
2009-08-17 08:00:00	SPY	ETF	98.66	100.5	98.66	99.15	1499731.0
2009-08-17 08:30:00	SPY	ETF	99.17	99.24	98.88	99.06	2181887.0
2009-08-17 09:00:00	SPY	ETF	99.07	100.79	98.84	98.86	2549549.0
2009-08-17 09:30:00	SPY	ETF	98.85	98.95	98.22	98.54	30404970.0
2009-08-17 10:00:00	SPY	ETF	98.55	98.62	98.3	98.5617	17809586.0
2009-08-17 10:30:00	SPY	ETF	98.56	98.6	98.34	98.4	12874074.0
2009-08-17 11:00:00	SPY	ETF	98.4	98.58	98.17	98.53	17712732.0
2009-08-17 11:30:00	SPY	ETF	98.53	98.8386	98.48	98.69	12585777.0
2009-08-17 12:00:00	SPY	ETF	98.69	98.73	98.52	98.64	6873788.0
2009-08-17 12:30:00	SPY	ETF	98.63	98.67	98.51	98.57	4939716.0
2009-08-17 13:00:00	SPY	ETF	98.58	98.905	98.37	98.54	7973837.0
2009-08-17 13:30:00	SPY	ETF	98.53	98.65	98.34	98.626	14305674.0
2009-08-17 14:00:00	SPY	ETF	98.63	98.6401	98.43	98.63	5866617.0
2009-08-17 14:30:00	SPY	ETF	98.62	98.65	98.37	98.46	11486817.0
2009-08-17 15:00:00	SPY	ETF	98.46	98.62	98.23	98.37	13133199.0
2009-08-17 15:30:00	SPY	ETF	98.36	98.91	98.115	98.23	38334750.0
2009-08-17 16:00:00	SPY	ETF	98.24	98.5	98.02	98.26	10265998.0
2009-08-17 16:30:00	SPY	ETF	98.27	100.6942	98.1	98.27	8236934.0
2009-08-17 17:00:00	SPY	ETF	98.27	98.42	98.15	98.4	1215953.0
2009-08-17 17:30:00	SPY	ETF	98.18	98.39	98.12	98.14	34067.0
2009-08-17 18:00:00	SPY	ETF	98.15	98.27	98.14	98.17	132618.0
2009-08-17 18:30:00	SPY	ETF	98.18	98.455	98.17	98.24	23030.0
2009-08-17 19:00:00	SPY	ETF	98.22	98.24	98.2	98.22	7060.0
2009-08-17 19:30:00	SPY	ETF	98.2	98.36	98.17	98.35	37535.0
2009-08-17 04:00:00	QQQ	ETF	38.97	38.99	38.97	38.99	13580.0
2009-08-17 04:30:00	QQQ	ETF	39.11	39.11	39.01	39.01	3000.0
2009-08-17 05:00:00	QQQ	ETF	39.0	39.0	39.0	39.0	100.0
2009-08-17 05:30:00	QQQ	ETF	38.98	39.08	38.98	39.08	341.0
2009-08-17 06:00:00	QQQ	ETF	39.08	39.1	39.08	39.1	20550.0
2009-08-17 06:30:00	QQQ	ETF	39.07	39.07	39.01	39.02	9867.0
2009-08-17 07:00:00	QQQ	ETF	39.04	39.07	38.93	39.01	488153.0
2009-08-17 07:30:00	QQQ	ETF	39.02	39.04	38.93	38.94	348839.0
2009-08-17 08:00:00	QQQ	ETF	38.97	39.5	38.94	39.17	601605.0
2009-08-17 08:30:00	QQQ	ETF	39.17	39.2	39.05	39.11	665187.0
2009-08-17 09:00:00	QQQ	ETF	39.11	39.15	38.97	38.98	890075.0
2009-08-17 09:30:00	QQQ	ETF	38.97	39.01	38.66	38.87	23521172.0
2009-08-17 10:00:00	QQQ	ETF	38.87	38.88	38.7099	38.7588	10785253.0
2009-08-17 10:30:00	QQQ	ETF	38.75	38.78	38.66	38.69	7964734.0
2009-08-17 11:00:00	QQQ	ETF	38.69	38.69	38.55	38.67	7358467.0
2009-08-17 11:30:00	QQQ	ETF	38.67	38.76	38.65	38.7099	3828640.0
2009-08-17 12:00:00	QQQ	ETF	38.7096	38.72	38.64	38.6925	3171733.0
2009-08-17 12:30:00	QQQ	ETF	38.7	38.72	38.65	38.67	3154012.0

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

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