PREVIEW / etf_30min / 2008-07-17

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-07-17.parquet
  size:    182 KB
  rows:    6,229

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-17 04:00:00	SPY	ETF	124.02	124.02	124.02	124.02	200.0
2008-07-17 04:30:00	SPY	ETF	123.98	123.98	123.98	123.98	100.0
2008-07-17 05:00:00	SPY	ETF	123.93	123.93	123.93	123.93	5000.0
2008-07-17 05:30:00	SPY	ETF	124.21	124.29	124.2	124.29	3100.0
2008-07-17 06:00:00	SPY	ETF	124.25	124.46	124.12	124.46	168400.0
2008-07-17 06:30:00	SPY	ETF	124.45	124.92	124.4	124.79	405700.0
2008-07-17 07:00:00	SPY	ETF	124.9	125.41	124.9	125.41	889938.0
2008-07-17 07:30:00	SPY	ETF	125.38	125.4	125.09	125.11	872509.0
2008-07-17 08:00:00	SPY	ETF	123.73	125.22	123.73	124.81	2473743.0
2008-07-17 08:30:00	SPY	ETF	124.85	125.39	124.7488	125.18	4208119.0
2008-07-17 09:00:00	SPY	ETF	125.18	125.21	125.0	125.15	3016085.0
2008-07-17 09:30:00	SPY	ETF	125.14	125.86	124.96	125.13	42874892.0
2008-07-17 10:00:00	SPY	ETF	125.13	125.32	124.66	124.959	37871776.0
2008-07-17 10:30:00	SPY	ETF	124.96	125.53	124.52	124.728	26010822.0
2008-07-17 11:00:00	SPY	ETF	124.72	124.92	124.09	124.77	29834706.0
2008-07-17 11:30:00	SPY	ETF	124.77	125.22	124.68	125.04	20532976.0
2008-07-17 12:00:00	SPY	ETF	125.04	125.04	124.68	124.84	8959030.0
2008-07-17 12:30:00	SPY	ETF	124.85	125.06	124.52	124.9398	10357131.0
2008-07-17 13:00:00	SPY	ETF	124.93	125.81	124.8	125.54	30848639.0
2008-07-17 13:30:00	SPY	ETF	125.55	126.19	125.53	125.955	24368561.0
2008-07-17 14:00:00	SPY	ETF	125.96	126.26	125.91	126.14	18341487.0
2008-07-17 14:30:00	SPY	ETF	126.15	126.15	125.2	125.39	28872664.0
2008-07-17 15:00:00	SPY	ETF	125.4	125.75	125.33	125.55	25703288.0
2008-07-17 15:30:00	SPY	ETF	125.54	125.94	124.87	125.91	28166052.0
2008-07-17 16:00:00	SPY	ETF	126.03	126.06	124.5	124.9	16371232.0
2008-07-17 16:30:00	SPY	ETF	124.9	125.9	124.6	124.7	5789169.0
2008-07-17 17:00:00	SPY	ETF	124.71	125.3751	124.32	124.48	3932713.0
2008-07-17 17:30:00	SPY	ETF	124.45	124.5	124.32	124.41	181129.0
2008-07-17 18:00:00	SPY	ETF	124.44	124.6	124.42	124.48	52017.0
2008-07-17 18:30:00	SPY	ETF	124.57	124.61	124.47	124.53	20470.0
2008-07-17 19:00:00	SPY	ETF	124.5	124.5	124.44	124.5	5301.0
2008-07-17 19:30:00	SPY	ETF	124.5	124.58	124.44	124.46	15030.0
2008-07-17 05:00:00	QQQ	ETF	45.18	45.18	45.17	45.17	400.0
2008-07-17 05:30:00	QQQ	ETF	45.2	45.31	45.2	45.31	700.0
2008-07-17 06:00:00	QQQ	ETF	45.33	45.35	45.24	45.34	37500.0
2008-07-17 06:30:00	QQQ	ETF	45.39	45.6	45.39	45.6	12700.0
2008-07-17 07:00:00	QQQ	ETF	45.62	45.75	45.62	45.72	324636.0
2008-07-17 07:30:00	QQQ	ETF	45.74	45.77	45.62	45.64	281620.0
2008-07-17 08:00:00	QQQ	ETF	45.64	45.68	45.55	45.58	1198158.0
2008-07-17 08:30:00	QQQ	ETF	45.57	45.76	45.57	45.67	1552529.0
2008-07-17 09:00:00	QQQ	ETF	45.66	45.67	45.56	45.57	1949431.0
2008-07-17 09:30:00	QQQ	ETF	45.56	45.78	45.36	45.38	28795225.0
2008-07-17 10:00:00	QQQ	ETF	45.37	45.48	45.17	45.3	22488696.0
2008-07-17 10:30:00	QQQ	ETF	45.3	45.41	45.16	45.23	12349360.0
2008-07-17 11:00:00	QQQ	ETF	45.23	45.33	44.9799	45.27	16215637.0
2008-07-17 11:30:00	QQQ	ETF	45.28	45.42	45.18	45.3	6959649.0
2008-07-17 12:00:00	QQQ	ETF	45.3	45.3	45.13	45.1895	6116116.0
2008-07-17 12:30:00	QQQ	ETF	45.1899	45.35	45.06	45.27	6021864.0
2008-07-17 13:00:00	QQQ	ETF	45.27	45.64	45.21	45.54	12396748.0
2008-07-17 13:30:00	QQQ	ETF	45.5302	45.8	45.52	45.7	13323433.0

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

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