PREVIEW / etf_30min / 2008-08-05

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-08-05.parquet
  size:    169 KB
  rows:    5,946

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-05 04:00:00	SPY	ETF	125.5	125.55	125.5	125.55	200.0
2008-08-05 04:30:00	SPY	ETF	125.78	126.1	125.78	125.9	5100.0
2008-08-05 05:00:00	SPY	ETF	125.98	126.0	125.85	125.85	3300.0
2008-08-05 05:30:00	SPY	ETF	125.91	126.02	125.91	126.02	300.0
2008-08-05 06:00:00	SPY	ETF	126.03	126.03	125.96	125.99	82500.0
2008-08-05 06:30:00	SPY	ETF	126.0	126.21	125.92	126.08	40700.0
2008-08-05 07:00:00	SPY	ETF	126.07	126.12	125.91	125.99	562020.0
2008-08-05 07:30:00	SPY	ETF	126.01	126.03	125.78	125.86	299955.0
2008-08-05 08:00:00	SPY	ETF	125.86	126.1	125.77	125.79	1453810.0
2008-08-05 08:30:00	SPY	ETF	125.78	126.01	125.76	125.95	1867913.0
2008-08-05 09:00:00	SPY	ETF	125.92	126.1	125.86	126.02	1095353.0
2008-08-05 09:30:00	SPY	ETF	126.02	126.49	125.9	126.45	25979241.0
2008-08-05 10:00:00	SPY	ETF	126.45	126.81	126.4	126.63	29021694.0
2008-08-05 10:30:00	SPY	ETF	126.62	126.89	126.55	126.89	9913522.0
2008-08-05 11:00:00	SPY	ETF	126.89	127.02	126.81	126.95	8464208.0
2008-08-05 11:30:00	SPY	ETF	126.95	127.18	126.85	127.17	8457641.0
2008-08-05 12:00:00	SPY	ETF	127.17	127.38	126.98	127.27	8287971.0
2008-08-05 12:30:00	SPY	ETF	127.26	127.28	127.08	127.25	8097587.0
2008-08-05 13:00:00	SPY	ETF	127.24	127.3	127.16	127.27	8732645.0
2008-08-05 13:30:00	SPY	ETF	127.27	127.5	127.25	127.3	10089386.0
2008-08-05 14:00:00	SPY	ETF	127.305	127.92	126.78	127.4301	42244268.0
2008-08-05 14:30:00	SPY	ETF	127.44	128.04	127.35	127.81	30041007.0
2008-08-05 15:00:00	SPY	ETF	127.8	127.97	127.68	127.83	15224909.0
2008-08-05 15:30:00	SPY	ETF	127.82	128.47	127.15	128.42	33181092.0
2008-08-05 16:00:00	SPY	ETF	128.421	128.56	127.1	128.43	4677846.0
2008-08-05 16:30:00	SPY	ETF	128.43	128.53	128.1	128.45	819919.0
2008-08-05 17:00:00	SPY	ETF	128.46	128.62	128.44	128.54	253590.0
2008-08-05 17:30:00	SPY	ETF	128.58	128.616	128.54	128.58	94400.0
2008-08-05 18:00:00	SPY	ETF	128.6	128.62	128.36	128.45	129564.0
2008-08-05 18:30:00	SPY	ETF	128.49	128.5	128.45	128.5	5050.0
2008-08-05 19:00:00	SPY	ETF	128.49	128.54	128.49	128.54	9500.0
2008-08-05 19:30:00	SPY	ETF	128.52	128.54	128.5	128.54	32203.0
2008-08-05 04:00:00	QQQ	ETF	44.76	44.76	44.76	44.76	500.0
2008-08-05 04:30:00	QQQ	ETF	44.86	44.96	44.86	44.96	1700.0
2008-08-05 05:00:00	QQQ	ETF	44.98	45.0	44.98	45.0	200.0
2008-08-05 06:00:00	QQQ	ETF	44.92	44.95	44.9	44.9	74400.0
2008-08-05 06:30:00	QQQ	ETF	44.9	44.96	44.9	44.96	76300.0
2008-08-05 07:00:00	QQQ	ETF	44.92	44.92	44.81	44.86	680057.0
2008-08-05 07:30:00	QQQ	ETF	44.87	44.89	44.8	44.81	178915.0
2008-08-05 08:00:00	QQQ	ETF	44.81	44.87	44.8	44.82	1131214.0
2008-08-05 08:30:00	QQQ	ETF	44.82	44.91	44.82	44.86	492548.0
2008-08-05 09:00:00	QQQ	ETF	44.85	44.95	44.84	44.91	939676.0
2008-08-05 09:30:00	QQQ	ETF	44.9	45.06	44.84	45.05	15751247.0
2008-08-05 10:00:00	QQQ	ETF	45.04	45.2	45.03	45.07	13801132.0
2008-08-05 10:30:00	QQQ	ETF	45.07	45.18	45.04	45.18	5960879.0
2008-08-05 11:00:00	QQQ	ETF	45.18	45.38	45.161	45.32	6782162.0
2008-08-05 11:30:00	QQQ	ETF	45.33	45.43	45.29	45.4201	6056913.0
2008-08-05 12:00:00	QQQ	ETF	45.43	45.43	45.3	45.39	4000961.0
2008-08-05 12:30:00	QQQ	ETF	45.38	45.4	45.31	45.3812	3786167.0
2008-08-05 13:00:00	QQQ	ETF	45.39	45.43	45.34	45.39	3660392.0

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

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