PREVIEW / etf_30min / 2008-07-01

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-07-01.parquet
  size:    180 KB
  rows:    6,192

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-01 04:30:00	SPY	ETF	127.8	127.8	127.5	127.5	200.0
2008-07-01 05:00:00	SPY	ETF	127.34	127.34	127.0	127.0	700.0
2008-07-01 05:30:00	SPY	ETF	126.86	126.86	126.68	126.68	3200.0
2008-07-01 06:00:00	SPY	ETF	126.67	126.7	126.6	126.7	113400.0
2008-07-01 06:30:00	SPY	ETF	126.7	126.8	126.45	126.6	442300.0
2008-07-01 07:00:00	SPY	ETF	126.6	126.73	126.5	126.55	1912244.0
2008-07-01 07:30:00	SPY	ETF	126.55	126.84	126.53	126.65	658491.0
2008-07-01 08:00:00	SPY	ETF	126.65	127.34	126.51	126.7	2187530.0
2008-07-01 08:30:00	SPY	ETF	126.71	126.76	126.53	126.62	1531870.0
2008-07-01 09:00:00	SPY	ETF	126.62	127.98	126.34	126.52	3613863.0
2008-07-01 09:30:00	SPY	ETF	126.52	127.13	126.48	127.07	25399199.0
2008-07-01 10:00:00	SPY	ETF	127.06	127.92	126.98	127.36	40843667.0
2008-07-01 10:30:00	SPY	ETF	127.36	128.0	127.35	128.0	25764514.0
2008-07-01 11:00:00	SPY	ETF	128.0	128.24	127.53	127.61	21985758.0
2008-07-01 11:30:00	SPY	ETF	127.61	127.7	127.04	127.14	17854764.0
2008-07-01 12:00:00	SPY	ETF	127.14	127.14	125.93	126.02	30514203.0
2008-07-01 12:30:00	SPY	ETF	126.02	126.62	125.99	126.5001	18993566.0
2008-07-01 13:00:00	SPY	ETF	126.51	127.8891	126.18	126.59	19830660.0
2008-07-01 13:30:00	SPY	ETF	126.58	127.22	126.23	126.91	25937520.0
2008-07-01 14:00:00	SPY	ETF	126.91	127.79	126.88	127.49	36775217.0
2008-07-01 14:30:00	SPY	ETF	127.49	128.46	127.36	128.0	30147165.0
2008-07-01 15:00:00	SPY	ETF	128.011	128.16	127.64	127.83	25282878.0
2008-07-01 15:30:00	SPY	ETF	127.82	128.43	127.75	128.37	24644300.0
2008-07-01 16:00:00	SPY	ETF	128.371	128.48	127.8891	128.42	5272361.0
2008-07-01 16:30:00	SPY	ETF	128.44	128.5	127.45	128.45	683268.0
2008-07-01 17:00:00	SPY	ETF	128.45	128.57	128.38	128.52	1543785.0
2008-07-01 17:30:00	SPY	ETF	128.55	128.61	127.89	128.56	1605015.0
2008-07-01 18:00:00	SPY	ETF	128.56	128.56	128.47	128.48	19580.0
2008-07-01 18:30:00	SPY	ETF	128.48	128.51	128.47	128.48	12871.0
2008-07-01 19:00:00	SPY	ETF	128.48	128.5	128.41	128.41	1650.0
2008-07-01 19:30:00	SPY	ETF	128.41	128.47	128.39	128.42	7140.0
2008-07-01 04:30:00	QQQ	ETF	45.09	45.09	44.81	44.81	1600.0
2008-07-01 05:00:00	QQQ	ETF	44.77	44.77	44.75	44.75	500.0
2008-07-01 05:30:00	QQQ	ETF	44.71	44.71	44.61	44.66	2700.0
2008-07-01 06:00:00	QQQ	ETF	44.68	44.69	44.6	44.66	3800.0
2008-07-01 06:30:00	QQQ	ETF	44.67	44.67	44.5	44.53	32000.0
2008-07-01 07:00:00	QQQ	ETF	44.53	44.58	44.51	44.54	346141.0
2008-07-01 07:30:00	QQQ	ETF	44.54	44.66	44.54	44.6	330779.0
2008-07-01 08:00:00	QQQ	ETF	44.62	44.75	44.59	44.72	1372851.0
2008-07-01 08:30:00	QQQ	ETF	44.73	44.76	44.71	44.74	1683531.0
2008-07-01 09:00:00	QQQ	ETF	44.74	45.17	44.61	44.85	3285621.0
2008-07-01 09:30:00	QQQ	ETF	44.84	45.03	44.72	44.98	20437718.0
2008-07-01 10:00:00	QQQ	ETF	44.97	45.37	44.93	45.14	28127979.0
2008-07-01 10:30:00	QQQ	ETF	45.1401	45.49	45.1	45.49	16439446.0
2008-07-01 11:00:00	QQQ	ETF	45.49	45.58	45.34	45.39	12119890.0
2008-07-01 11:30:00	QQQ	ETF	45.39	45.45	45.05	45.1	9998668.0
2008-07-01 12:00:00	QQQ	ETF	45.1	45.14	44.68	44.72	19522498.0
2008-07-01 12:30:00	QQQ	ETF	44.73	44.97	44.7	44.9301	10981231.0
2008-07-01 13:00:00	QQQ	ETF	44.93	45.15	44.84	45.05	11849617.0
2008-07-01 13:30:00	QQQ	ETF	45.05	45.45	44.85	45.22	19948949.0

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

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