PREVIEW / etf_30min / 2009-08-05

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-08-05.parquet
  size:    230 KB
  rows:    7,580

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-05 04:00:00	SPY	ETF	100.59	100.66	100.51	100.51	2850.0
2009-08-05 04:30:00	SPY	ETF	100.62	100.62	100.6	100.6	200.0
2009-08-05 05:00:00	SPY	ETF	100.63	100.79	100.63	100.79	4200.0
2009-08-05 05:30:00	SPY	ETF	100.8	100.86	100.8	100.86	1436.0
2009-08-05 06:00:00	SPY	ETF	100.87	100.92	100.85	100.85	2300.0
2009-08-05 06:30:00	SPY	ETF	100.9	101.0	100.9	101.0	3526.0
2009-08-05 07:00:00	SPY	ETF	100.98	100.98	100.78	100.93	92417.0
2009-08-05 07:30:00	SPY	ETF	100.96	101.07	100.83	100.84	239980.0
2009-08-05 08:00:00	SPY	ETF	100.86	101.03	100.65	100.68	1954328.0
2009-08-05 08:30:00	SPY	ETF	100.67	100.7	100.55	100.66	613483.0
2009-08-05 09:00:00	SPY	ETF	100.67	100.87	100.66	100.77	795681.0
2009-08-05 09:30:00	SPY	ETF	100.77	100.855	100.13	100.25	24375660.0
2009-08-05 10:00:00	SPY	ETF	100.25	100.3	99.61	99.95	25121317.0
2009-08-05 10:30:00	SPY	ETF	99.94	99.95	99.58	99.87	14416791.0
2009-08-05 11:00:00	SPY	ETF	99.86	100.07	99.76	99.98	9309248.0
2009-08-05 11:30:00	SPY	ETF	99.99	100.01	99.76	99.871	5861888.0
2009-08-05 12:00:00	SPY	ETF	99.88	100.17	99.77	100.06	6827544.0
2009-08-05 12:30:00	SPY	ETF	100.05	100.12	99.88	99.92	5593819.0
2009-08-05 13:00:00	SPY	ETF	99.92	100.26	99.72	100.2	10613581.0
2009-08-05 13:30:00	SPY	ETF	100.21	100.32	100.08	100.09	10649589.0
2009-08-05 14:00:00	SPY	ETF	100.1	100.26	100.03	100.2	6477378.0
2009-08-05 14:30:00	SPY	ETF	100.2	100.67	100.16	100.61	13999829.0
2009-08-05 15:00:00	SPY	ETF	100.6	100.79	100.2	100.75	8815375.0
2009-08-05 15:30:00	SPY	ETF	100.75	100.77	100.25	100.41	29105085.0
2009-08-05 16:00:00	SPY	ETF	100.4	100.61	99.81	100.49	7182844.0
2009-08-05 16:30:00	SPY	ETF	100.49	100.5	100.19	100.21	1025456.0
2009-08-05 17:00:00	SPY	ETF	100.24	100.29	100.12	100.15	526404.0
2009-08-05 17:30:00	SPY	ETF	100.14	100.7358	100.1	100.15	436566.0
2009-08-05 18:00:00	SPY	ETF	100.14	100.17	100.09	100.1	26050.0
2009-08-05 18:30:00	SPY	ETF	100.09	100.13	100.07	100.1	11700.0
2009-08-05 19:00:00	SPY	ETF	100.13	100.14	100.1	100.1	11785.0
2009-08-05 19:30:00	SPY	ETF	100.09	100.15	100.08	100.13	17020.0
2009-08-05 06:00:00	QQQ	ETF	40.08	40.1	40.08	40.1	200.0
2009-08-05 06:30:00	QQQ	ETF	40.1	40.13	40.1	40.13	10000.0
2009-08-05 07:00:00	QQQ	ETF	40.09	40.09	40.05	40.08	69000.0
2009-08-05 07:30:00	QQQ	ETF	40.14	40.16	40.07	40.08	106200.0
2009-08-05 08:00:00	QQQ	ETF	40.08	40.15	40.02	40.08	403380.0
2009-08-05 08:30:00	QQQ	ETF	40.07	40.09	40.04	40.06	248006.0
2009-08-05 09:00:00	QQQ	ETF	40.07	40.16	40.07	40.14	334320.0
2009-08-05 09:30:00	QQQ	ETF	40.13	40.14	39.72	39.7501	17478832.0
2009-08-05 10:00:00	QQQ	ETF	39.76	39.78	39.54	39.74	14041085.0
2009-08-05 10:30:00	QQQ	ETF	39.74	39.74	39.55	39.65	7616731.0
2009-08-05 11:00:00	QQQ	ETF	39.65	39.71	39.58	39.6165	3932117.0
2009-08-05 11:30:00	QQQ	ETF	39.62	39.64	39.5	39.54	4600900.0
2009-08-05 12:00:00	QQQ	ETF	39.54	39.66	39.5	39.58	4684131.0
2009-08-05 12:30:00	QQQ	ETF	39.58	39.6	39.51	39.51	3454122.0
2009-08-05 13:00:00	QQQ	ETF	39.52	39.7	39.46	39.6799	10123007.0
2009-08-05 13:30:00	QQQ	ETF	39.6701	39.69	39.55	39.59	5467883.0
2009-08-05 14:00:00	QQQ	ETF	39.59	39.64	39.56	39.61	3415559.0
2009-08-05 14:30:00	QQQ	ETF	39.62	39.81	39.59	39.77	7042328.0

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

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