PREVIEW / etf_30min / 2008-07-24

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-07-24.parquet
  size:    175 KB
  rows:    6,056

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
2008-07-24 05:00:00	SPY	ETF	128.09	128.09	128.09	128.09	100.0
2008-07-24 05:30:00	SPY	ETF	127.82	127.84	127.82	127.84	1300.0
2008-07-24 06:00:00	SPY	ETF	127.8	127.98	127.8	127.91	35300.0
2008-07-24 06:30:00	SPY	ETF	127.91	127.91	127.8	127.88	152500.0
2008-07-24 07:00:00	SPY	ETF	127.87	127.92	127.62	127.71	212335.0
2008-07-24 07:30:00	SPY	ETF	127.71	128.08	127.71	127.98	799367.0
2008-07-24 08:00:00	SPY	ETF	127.98	128.12	127.79	128.01	611106.0
2008-07-24 08:30:00	SPY	ETF	127.98	128.04	127.74	128.04	2403917.0
2008-07-24 09:00:00	SPY	ETF	128.05	128.41	128.01	128.34	1400964.0
2008-07-24 09:30:00	SPY	ETF	128.34	128.41	127.57	127.7201	24299889.0
2008-07-24 10:00:00	SPY	ETF	127.72	127.72	127.1	127.3699	27025204.0
2008-07-24 10:30:00	SPY	ETF	127.36	127.54	127.18	127.198	21068542.0
2008-07-24 11:00:00	SPY	ETF	127.19	127.32	126.62	126.62	22996793.0
2008-07-24 11:30:00	SPY	ETF	126.63	126.92	126.55	126.89	14650785.0
2008-07-24 12:00:00	SPY	ETF	126.89	126.99	126.63	126.65	7431049.0
2008-07-24 12:30:00	SPY	ETF	126.65	126.87	126.43	126.71	10760441.0
2008-07-24 13:00:00	SPY	ETF	126.71	126.8	126.42	126.65	10263614.0
2008-07-24 13:30:00	SPY	ETF	126.66	126.73	126.41	126.54	8821744.0
2008-07-24 14:00:00	SPY	ETF	126.54	126.6	126.03	126.18	22247858.0
2008-07-24 14:30:00	SPY	ETF	126.18	126.23	125.83	126.1099	12472517.0
2008-07-24 15:00:00	SPY	ETF	126.1	126.38	125.6	125.68	21556831.0
2008-07-24 15:30:00	SPY	ETF	125.6801	125.77	125.16	125.43	29739276.0
2008-07-24 16:00:00	SPY	ETF	125.39	125.55	125.18	125.4	4604744.0
2008-07-24 16:30:00	SPY	ETF	125.41	126.116	125.36	125.36	1579718.0
2008-07-24 17:00:00	SPY	ETF	125.42	125.55	125.42	125.54	65860.0
2008-07-24 17:30:00	SPY	ETF	125.49	125.56	125.49	125.55	23402.0
2008-07-24 18:00:00	SPY	ETF	125.55	125.57	125.52	125.53	14477.0
2008-07-24 18:30:00	SPY	ETF	125.54	125.57	125.53	125.53	5650.0
2008-07-24 19:00:00	SPY	ETF	125.52	125.52	125.44	125.49	21763.0
2008-07-24 19:30:00	SPY	ETF	125.52	125.56	125.46	125.52	13561.0
2008-07-24 04:00:00	QQQ	ETF	45.54	45.54	45.54	45.54	1500.0
2008-07-24 04:30:00	QQQ	ETF	45.53	45.53	45.49	45.5	2400.0
2008-07-24 06:00:00	QQQ	ETF	45.48	45.51	45.48	45.48	20700.0
2008-07-24 06:30:00	QQQ	ETF	45.42	45.42	45.42	45.42	1000.0
2008-07-24 07:00:00	QQQ	ETF	45.44	45.44	45.38	45.39	51879.0
2008-07-24 07:30:00	QQQ	ETF	45.42	45.57	45.42	45.52	328323.0
2008-07-24 08:00:00	QQQ	ETF	45.52	45.56	45.5	45.56	359162.0
2008-07-24 08:30:00	QQQ	ETF	45.53	45.59	45.43	45.59	857295.0
2008-07-24 09:00:00	QQQ	ETF	45.59	45.67	45.57	45.58	1530773.0
2008-07-24 09:30:00	QQQ	ETF	45.59	45.61	45.26	45.4	20192145.0
2008-07-24 10:00:00	QQQ	ETF	45.39	45.39	45.03	45.14	15700693.0
2008-07-24 10:30:00	QQQ	ETF	45.135	45.29	45.1	45.17	7743822.0
2008-07-24 11:00:00	QQQ	ETF	45.17	45.22	44.95	44.97	11127191.0
2008-07-24 11:30:00	QQQ	ETF	44.97	45.15	44.91	45.14	6098055.0
2008-07-24 12:00:00	QQQ	ETF	45.1399	45.18	44.99	44.99	2328137.0
2008-07-24 12:30:00	QQQ	ETF	44.99	45.26	44.98	45.07	6061502.0
2008-07-24 13:00:00	QQQ	ETF	45.07	45.22	44.92	45.19	8347671.0
2008-07-24 13:30:00	QQQ	ETF	45.18	45.26	45.04	45.2	9522088.0
2008-07-24 14:00:00	QQQ	ETF	45.2	45.23	44.97	45.068	7986560.0
2008-07-24 14:30:00	QQQ	ETF	45.07	45.12	44.92	45.1	7360654.0

> showing 50 of 6,056 rows — these rows as CSV

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