PREVIEW / etf_30min / 2008-08-15

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-08-15.parquet
  size:    163 KB
  rows:    5,840

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-08-15 04:00:00	SPY	ETF	130.17	130.17	130.11	130.11	300.0
2008-08-15 05:30:00	SPY	ETF	130.18	130.18	130.18	130.18	100.0
2008-08-15 06:00:00	SPY	ETF	130.01	130.01	130.01	130.01	100.0
2008-08-15 06:30:00	SPY	ETF	130.0	130.05	129.97	129.97	52200.0
2008-08-15 07:00:00	SPY	ETF	130.07	130.13	129.9	129.9	174050.0
2008-08-15 07:30:00	SPY	ETF	129.9	129.9	129.65	129.71	550308.0
2008-08-15 08:00:00	SPY	ETF	129.9	130.19	129.68	129.93	929503.0
2008-08-15 08:30:00	SPY	ETF	129.97	130.24	129.81	129.91	1574160.0
2008-08-15 09:00:00	SPY	ETF	129.9	129.94	129.77	129.92	1574898.0
2008-08-15 09:30:00	SPY	ETF	129.93	130.5	129.85	130.15	29051050.0
2008-08-15 10:00:00	SPY	ETF	130.15	130.155	129.3	129.69	29125448.0
2008-08-15 10:30:00	SPY	ETF	129.68	130.35	129.68	130.31	17232205.0
2008-08-15 11:00:00	SPY	ETF	130.31	130.38	129.96	130.225	15146116.0
2008-08-15 11:30:00	SPY	ETF	130.22	130.4	129.78	129.89	14453404.0
2008-08-15 12:00:00	SPY	ETF	129.89	129.98	129.63	129.78	6146777.0
2008-08-15 12:30:00	SPY	ETF	129.77	130.12	129.76	129.98	6728358.0
2008-08-15 13:00:00	SPY	ETF	129.99	130.07	129.84	129.9	6928533.0
2008-08-15 13:30:00	SPY	ETF	129.9	130.02	129.8	129.86	4696719.0
2008-08-15 14:00:00	SPY	ETF	129.855	129.91	129.63	129.68	8012276.0
2008-08-15 14:30:00	SPY	ETF	129.68	129.91	129.65	129.82	6328488.0
2008-08-15 15:00:00	SPY	ETF	129.82	130.12	129.81	130.07	9705185.0
2008-08-15 15:30:00	SPY	ETF	130.069	130.15	129.88	130.05	12911615.0
2008-08-15 16:00:00	SPY	ETF	130.05	130.24	129.95	130.22	6062804.0
2008-08-15 16:30:00	SPY	ETF	130.21	130.25	130.15	130.16	187968.0
2008-08-15 17:00:00	SPY	ETF	130.17	130.27	130.17	130.19	1236673.0
2008-08-15 17:30:00	SPY	ETF	130.24	130.25	130.22	130.25	11620.0
2008-08-15 18:00:00	SPY	ETF	130.25	130.26	130.24	130.24	550.0
2008-08-15 18:30:00	SPY	ETF	130.22	130.26	130.22	130.22	3168.0
2008-08-15 19:30:00	SPY	ETF	130.22	130.25	130.22	130.22	1436.0
2008-08-15 04:00:00	QQQ	ETF	48.43	48.43	48.43	48.43	100.0
2008-08-15 05:00:00	QQQ	ETF	48.42	48.42	48.42	48.42	2000.0
2008-08-15 05:30:00	QQQ	ETF	48.44	48.49	48.44	48.47	1500.0
2008-08-15 06:00:00	QQQ	ETF	48.41	48.41	48.41	48.41	500.0
2008-08-15 07:00:00	QQQ	ETF	48.45	48.48	48.41	48.42	99602.0
2008-08-15 07:30:00	QQQ	ETF	48.39	48.4	48.3	48.3	158686.0
2008-08-15 08:00:00	QQQ	ETF	48.3	48.47	48.3	48.39	358749.0
2008-08-15 08:30:00	QQQ	ETF	48.41	48.49	48.37	48.37	575874.0
2008-08-15 09:00:00	QQQ	ETF	48.37	48.37	48.28	48.36	725201.0
2008-08-15 09:30:00	QQQ	ETF	48.36	48.57	48.3	48.38	17660149.0
2008-08-15 10:00:00	QQQ	ETF	48.38	48.3875	48.0	48.12	23224667.0
2008-08-15 10:30:00	QQQ	ETF	48.12	48.51	48.12	48.48	17247041.0
2008-08-15 11:00:00	QQQ	ETF	48.49	48.49	48.27	48.38	5605056.0
2008-08-15 11:30:00	QQQ	ETF	48.39	48.46	48.16	48.2	8054359.0
2008-08-15 12:00:00	QQQ	ETF	48.19	48.3	48.15	48.2	3809248.0
2008-08-15 12:30:00	QQQ	ETF	48.21	48.35	48.191	48.28	4896899.0
2008-08-15 13:00:00	QQQ	ETF	48.29	48.32	48.22	48.23	3057557.0
2008-08-15 13:30:00	QQQ	ETF	48.22	48.25	48.11	48.13	3309006.0
2008-08-15 14:00:00	QQQ	ETF	48.13	48.16	48.0	48.065	6932441.0
2008-08-15 14:30:00	QQQ	ETF	48.06	48.12	47.96	48.09	8228055.0
2008-08-15 15:00:00	QQQ	ETF	48.09	48.25	48.075	48.24	4889028.0

> showing 50 of 5,840 rows — these rows as CSV

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