PREVIEW / etf_30min / 2008-07-08

all etf 30-min files

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

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-08 04:00:00	SPY	ETF	123.86	123.86	123.6	123.69	8500.0
2008-07-08 04:30:00	SPY	ETF	123.61	123.69	123.61	123.69	1200.0
2008-07-08 05:30:00	SPY	ETF	124.12	124.24	124.12	124.18	5500.0
2008-07-08 06:00:00	SPY	ETF	124.31	124.34	124.13	124.24	6000.0
2008-07-08 06:30:00	SPY	ETF	124.33	124.65	124.3	124.6	127300.0
2008-07-08 07:00:00	SPY	ETF	124.63	124.7	124.3	124.6	690000.0
2008-07-08 07:30:00	SPY	ETF	124.57	124.64	124.07	124.24	757238.0
2008-07-08 08:00:00	SPY	ETF	124.45	125.0	124.05	125.0	5016490.0
2008-07-08 08:30:00	SPY	ETF	124.98	125.26	124.67	124.79	5529612.0
2008-07-08 09:00:00	SPY	ETF	124.8	125.14	124.7	124.97	2378628.0
2008-07-08 09:30:00	SPY	ETF	124.99	125.63	124.62	125.19	40324288.0
2008-07-08 10:00:00	SPY	ETF	125.18	125.48	124.64	124.84	35983321.0
2008-07-08 10:30:00	SPY	ETF	124.84	125.09	124.2	124.76	33160622.0
2008-07-08 11:00:00	SPY	ETF	124.751	125.53	124.49	125.5	31319721.0
2008-07-08 11:30:00	SPY	ETF	125.5	125.51	125.02	125.21	18590625.0
2008-07-08 12:00:00	SPY	ETF	125.21	125.75	125.06	125.75	15184751.0
2008-07-08 12:30:00	SPY	ETF	125.75	125.92	125.45	125.54	15423029.0
2008-07-08 13:00:00	SPY	ETF	125.54	125.89	125.2	125.4	13977586.0
2008-07-08 13:30:00	SPY	ETF	125.41	125.45	124.87	125.0	18792873.0
2008-07-08 14:00:00	SPY	ETF	124.99	125.49	124.9	125.38	15187782.0
2008-07-08 14:30:00	SPY	ETF	125.4	126.49	125.31	126.46	37301119.0
2008-07-08 15:00:00	SPY	ETF	126.46	126.98	126.31	126.97	31884349.0
2008-07-08 15:30:00	SPY	ETF	126.97	127.39	126.69	127.29	33421139.0
2008-07-08 16:00:00	SPY	ETF	127.29	127.36	126.9542	127.26	8493659.0
2008-07-08 16:30:00	SPY	ETF	127.26	127.43	127.24	127.32	8010830.0
2008-07-08 17:00:00	SPY	ETF	127.32	127.34	127.29	127.34	122265.0
2008-07-08 17:30:00	SPY	ETF	127.32	127.42	127.31	127.34	72393.0
2008-07-08 18:00:00	SPY	ETF	127.4	127.45	127.32	127.45	13775.0
2008-07-08 18:30:00	SPY	ETF	127.37	127.37	127.32	127.33	9366.0
2008-07-08 19:00:00	SPY	ETF	127.33	127.37	127.3	127.37	27531.0
2008-07-08 19:30:00	SPY	ETF	127.33	127.35	127.3	127.35	26585.0
2008-07-08 04:00:00	QQQ	ETF	44.47	44.47	44.47	44.47	200.0
2008-07-08 05:00:00	QQQ	ETF	44.5	44.55	44.5	44.54	2100.0
2008-07-08 06:30:00	QQQ	ETF	44.71	44.79	44.66	44.77	31400.0
2008-07-08 07:00:00	QQQ	ETF	44.76	44.8	44.64	44.79	173242.0
2008-07-08 07:30:00	QQQ	ETF	44.79	44.82	44.61	44.67	225325.0
2008-07-08 08:00:00	QQQ	ETF	44.68	44.99	44.65	44.95	2241621.0
2008-07-08 08:30:00	QQQ	ETF	44.97	45.05	44.85	44.86	1557761.0
2008-07-08 09:00:00	QQQ	ETF	44.88	45.06	44.82	44.95	2112930.0
2008-07-08 09:30:00	QQQ	ETF	44.95	45.39	44.77	45.26	28068032.0
2008-07-08 10:00:00	QQQ	ETF	45.26	45.4	45.0	45.1499	19165632.0
2008-07-08 10:30:00	QQQ	ETF	45.14	45.25	44.83	45.0	14804717.0
2008-07-08 11:00:00	QQQ	ETF	45.0099	45.34	44.84	45.3188	11410490.0
2008-07-08 11:30:00	QQQ	ETF	45.31	45.32	45.13	45.17	7243720.0
2008-07-08 12:00:00	QQQ	ETF	45.17	45.42	45.11	45.41	8275989.0
2008-07-08 12:30:00	QQQ	ETF	45.4	45.55	45.36	45.415	11837834.0
2008-07-08 13:00:00	QQQ	ETF	45.4101	45.52	45.1625	45.28	9746006.0
2008-07-08 13:30:00	QQQ	ETF	45.27	45.2795	45.07	45.12	8391061.0
2008-07-08 14:00:00	QQQ	ETF	45.12	45.33	45.09	45.31	6003097.0
2008-07-08 14:30:00	QQQ	ETF	45.31	45.75	45.2999	45.73	20341017.0

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

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