PREVIEW / etf_30min / 2009-08-12

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-08-12.parquet
  size:    227 KB
  rows:    7,425

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-12 04:00:00	SPY	ETF	99.37	99.37	99.27	99.37	22279.0
2009-08-12 04:30:00	SPY	ETF	99.42	99.47	99.42	99.47	5800.0
2009-08-12 05:00:00	SPY	ETF	99.57	99.57	99.57	99.57	100.0
2009-08-12 05:30:00	SPY	ETF	99.51	99.57	99.43	99.57	600.0
2009-08-12 06:00:00	SPY	ETF	99.67	99.87	99.67	99.8	3400.0
2009-08-12 06:30:00	SPY	ETF	99.83	99.93	99.83	99.86	5400.0
2009-08-12 07:00:00	SPY	ETF	99.86	99.89	99.71	99.76	117421.0
2009-08-12 07:30:00	SPY	ETF	99.74	99.79	99.48	99.56	451160.0
2009-08-12 08:00:00	SPY	ETF	99.56	99.91	99.55	99.78	840122.0
2009-08-12 08:30:00	SPY	ETF	99.76	99.81	99.56	99.6	915566.0
2009-08-12 09:00:00	SPY	ETF	99.61	99.73	99.51	99.53	1258880.0
2009-08-12 09:30:00	SPY	ETF	99.56	100.59	99.54	100.57	23634029.0
2009-08-12 10:00:00	SPY	ETF	100.57	100.97	100.57	100.87	22685985.0
2009-08-12 10:30:00	SPY	ETF	100.87	101.09	100.74	100.9625	20103172.0
2009-08-12 11:00:00	SPY	ETF	100.97	101.03	100.86	100.97	8376750.0
2009-08-12 11:30:00	SPY	ETF	100.97	101.06	100.93	101.02	8071399.0
2009-08-12 12:00:00	SPY	ETF	101.02	101.09	100.87	100.945	6007021.0
2009-08-12 12:30:00	SPY	ETF	100.9499	101.04	100.8	101.02	7464123.0
2009-08-12 13:00:00	SPY	ETF	101.02	101.2	100.92	101.15	10801490.0
2009-08-12 13:30:00	SPY	ETF	101.15	101.15	100.93	101.028	8908867.0
2009-08-12 14:00:00	SPY	ETF	101.03	101.18	100.69	100.7	17610669.0
2009-08-12 14:30:00	SPY	ETF	100.7	101.45	100.49	101.44	24825816.0
2009-08-12 15:00:00	SPY	ETF	101.43	101.56	101.23	101.41	17911211.0
2009-08-12 15:30:00	SPY	ETF	101.41	101.56	100.65	100.78	25470049.0
2009-08-12 16:00:00	SPY	ETF	100.77	100.9898	99.6927	100.68	9849564.0
2009-08-12 16:30:00	SPY	ETF	100.68	100.88	100.66	100.84	1413835.0
2009-08-12 17:00:00	SPY	ETF	100.84	100.91	99.6927	100.86	1234363.0
2009-08-12 17:30:00	SPY	ETF	100.87	100.91	100.86	100.89	61467.0
2009-08-12 18:00:00	SPY	ETF	100.89	100.9	100.85	100.86	86411.0
2009-08-12 18:30:00	SPY	ETF	100.86	100.91	100.75	100.75	92814.0
2009-08-12 19:00:00	SPY	ETF	100.78	100.82	100.73	100.82	27076.0
2009-08-12 19:30:00	SPY	ETF	100.81	100.86	100.75	100.86	77997.0
2009-08-12 04:00:00	QQQ	ETF	39.17	39.17	39.17	39.17	100.0
2009-08-12 06:00:00	QQQ	ETF	39.37	39.37	39.37	39.37	137.0
2009-08-12 06:30:00	QQQ	ETF	39.39	39.39	39.39	39.39	9200.0
2009-08-12 07:00:00	QQQ	ETF	39.4	39.41	39.34	39.35	8425.0
2009-08-12 07:30:00	QQQ	ETF	39.34	39.34	39.27	39.28	34278.0
2009-08-12 08:00:00	QQQ	ETF	39.3	39.43	39.15	39.28	403637.0
2009-08-12 08:30:00	QQQ	ETF	39.27	39.31	39.21	39.26	208256.0
2009-08-12 09:00:00	QQQ	ETF	39.27	39.3	39.19	39.2	149222.0
2009-08-12 09:30:00	QQQ	ETF	39.21	39.85	39.2	39.82	17332660.0
2009-08-12 10:00:00	QQQ	ETF	39.83	39.96	39.79	39.9	16027345.0
2009-08-12 10:30:00	QQQ	ETF	39.9	39.97	39.84	39.96	6989547.0
2009-08-12 11:00:00	QQQ	ETF	39.96	40.0	39.91	39.95	6296053.0
2009-08-12 11:30:00	QQQ	ETF	39.9501	39.99	39.91	39.95	4423946.0
2009-08-12 12:00:00	QQQ	ETF	39.94	39.98	39.88	39.9209	1972574.0
2009-08-12 12:30:00	QQQ	ETF	39.92	39.95	39.87	39.94	3587114.0
2009-08-12 13:00:00	QQQ	ETF	39.94	40.01	39.89	39.998	5117052.0
2009-08-12 13:30:00	QQQ	ETF	39.99	40.0	39.87	39.8801	4297503.0
2009-08-12 14:00:00	QQQ	ETF	39.89	39.97	39.8	39.8	9337121.0

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

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