PREVIEW / etf_30min / 2008-07-22

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-07-22.parquet
  size:    174 KB
  rows:    6,018

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-22 04:30:00	SPY	ETF	125.1	125.13	125.1	125.13	400.0
2008-07-22 05:00:00	SPY	ETF	125.2	125.4	125.2	125.4	1000.0
2008-07-22 05:30:00	SPY	ETF	125.28	125.28	125.28	125.28	100.0
2008-07-22 06:00:00	SPY	ETF	125.35	125.38	125.03	125.1	128100.0
2008-07-22 06:30:00	SPY	ETF	125.1	125.2	124.9	125.14	593200.0
2008-07-22 07:00:00	SPY	ETF	125.03	125.04	124.8	125.0	503532.0
2008-07-22 07:30:00	SPY	ETF	125.08	125.21	125.02	125.1	713960.0
2008-07-22 08:00:00	SPY	ETF	125.1	125.32	124.85	125.13	1963184.0
2008-07-22 08:30:00	SPY	ETF	125.14	125.35	125.09	125.28	1574971.0
2008-07-22 09:00:00	SPY	ETF	125.28	125.31	125.1	125.13	1127023.0
2008-07-22 09:30:00	SPY	ETF	125.15	125.43	124.89	125.4	32992951.0
2008-07-22 10:00:00	SPY	ETF	125.39	126.01	124.85	125.64	32297622.0
2008-07-22 10:30:00	SPY	ETF	125.65	125.88	125.49	125.65	19434723.0
2008-07-22 11:00:00	SPY	ETF	125.65	126.34	125.63	126.26	24065824.0
2008-07-22 11:30:00	SPY	ETF	126.26	126.33	125.87	125.98	17130710.0
2008-07-22 12:00:00	SPY	ETF	125.97	126.35	125.86	125.995	16092080.0
2008-07-22 12:30:00	SPY	ETF	125.99	126.09	125.76	126.03	11977729.0
2008-07-22 13:00:00	SPY	ETF	126.03	126.18	125.86	126.04	11463319.0
2008-07-22 13:30:00	SPY	ETF	126.05	126.27	125.93	126.15	14798875.0
2008-07-22 14:00:00	SPY	ETF	126.15	126.18	125.74	126.13	21047446.0
2008-07-22 14:30:00	SPY	ETF	126.12	126.5	125.91	126.39	20602316.0
2008-07-22 15:00:00	SPY	ETF	126.39	126.77	126.33	126.76	14962149.0
2008-07-22 15:30:00	SPY	ETF	126.76	127.8	126.67	127.69	36557168.0
2008-07-22 16:00:00	SPY	ETF	127.6599	127.8	125.8	127.65	7684919.0
2008-07-22 16:30:00	SPY	ETF	127.57	127.7	126.0013	127.42	5293635.0
2008-07-22 17:00:00	SPY	ETF	127.4	127.48	127.32	127.42	367252.0
2008-07-22 17:30:00	SPY	ETF	127.4	127.46	127.4	127.41	24379.0
2008-07-22 18:00:00	SPY	ETF	127.41	127.48	127.37	127.43	78018.0
2008-07-22 18:30:00	SPY	ETF	127.42	127.42	127.4	127.4	6450.0
2008-07-22 19:00:00	SPY	ETF	127.43	127.46	127.4	127.46	1700.0
2008-07-22 19:30:00	SPY	ETF	127.46	127.51	127.46	127.48	4270.0
2008-07-22 04:00:00	QQQ	ETF	43.99	44.02	43.99	44.02	500.0
2008-07-22 04:30:00	QQQ	ETF	44.05	44.05	44.05	44.05	500.0
2008-07-22 05:00:00	QQQ	ETF	44.07	44.07	44.07	44.07	100.0
2008-07-22 05:30:00	QQQ	ETF	44.08	44.08	44.08	44.08	100.0
2008-07-22 06:00:00	QQQ	ETF	44.07	44.07	44.03	44.03	1100.0
2008-07-22 06:30:00	QQQ	ETF	44.01	44.01	43.98	44.0	800.0
2008-07-22 07:00:00	QQQ	ETF	43.96	44.02	43.93	44.02	207741.0
2008-07-22 07:30:00	QQQ	ETF	44.03	44.1	44.0	44.03	368026.0
2008-07-22 08:00:00	QQQ	ETF	44.02	44.11	43.96	44.07	1160189.0
2008-07-22 08:30:00	QQQ	ETF	44.07	44.11	44.04	44.07	764236.0
2008-07-22 09:00:00	QQQ	ETF	44.08	44.1	44.0	44.02	1382980.0
2008-07-22 09:30:00	QQQ	ETF	44.02	44.19	43.86	44.1	20729846.0
2008-07-22 10:00:00	QQQ	ETF	44.1	44.41	44.08	44.2401	17961753.0
2008-07-22 10:30:00	QQQ	ETF	44.24	44.3	44.0	44.08	13441186.0
2008-07-22 11:00:00	QQQ	ETF	44.07	44.29	44.04	44.28	15404188.0
2008-07-22 11:30:00	QQQ	ETF	44.27	44.36	44.1	44.1599	10883893.0
2008-07-22 12:00:00	QQQ	ETF	44.15	44.24	44.11	44.1805	4904045.0
2008-07-22 12:30:00	QQQ	ETF	44.18	44.215	44.1	44.16	6063555.0
2008-07-22 13:00:00	QQQ	ETF	44.162	44.27	44.1	44.21	5025410.0

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

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