PREVIEW / etf_30min / 2010-06-04

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-06-04.parquet
  size:    269 KB
  rows:    8,763

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
2010-06-04 04:00:00	SPY	ETF	110.96	111.05	110.96	111.05	1600.0
2010-06-04 04:30:00	SPY	ETF	111.1	111.19	111.09	111.09	11400.0
2010-06-04 05:00:00	SPY	ETF	111.16	111.16	111.16	111.16	100.0
2010-06-04 05:30:00	SPY	ETF	111.16	111.19	111.16	111.19	5000.0
2010-06-04 06:00:00	SPY	ETF	111.07	111.07	110.9	110.9	17100.0
2010-06-04 06:30:00	SPY	ETF	110.75	110.88	110.58	110.6	36821.0
2010-06-04 07:00:00	SPY	ETF	110.62	110.62	109.92	110.16	3034158.0
2010-06-04 07:30:00	SPY	ETF	110.16	110.2	109.68	109.76	1111055.0
2010-06-04 08:00:00	SPY	ETF	109.76	110.55	109.74	110.11	4458058.0
2010-06-04 08:30:00	SPY	ETF	109.91	109.91	108.17	108.63	17223284.0
2010-06-04 09:00:00	SPY	ETF	108.64	108.69	108.28	108.62	4399824.0
2010-06-04 09:30:00	SPY	ETF	108.61	109.14	108.5	108.98	41863111.0
2010-06-04 10:00:00	SPY	ETF	108.98	109.33	108.7	109.18	25257105.0
2010-06-04 10:30:00	SPY	ETF	109.18	109.28	108.8	108.84	15464234.0
2010-06-04 11:00:00	SPY	ETF	108.83	109.03	108.29	108.35	16496762.0
2010-06-04 11:30:00	SPY	ETF	108.36	108.68	108.25	108.44	16205444.0
2010-06-04 12:00:00	SPY	ETF	108.4376	108.57	107.9	108.23	19905452.0
2010-06-04 12:30:00	SPY	ETF	108.24	108.42	108.03	108.42	7388051.0
2010-06-04 13:00:00	SPY	ETF	108.42	108.45	107.8	108.03	15567877.0
2010-06-04 13:30:00	SPY	ETF	108.03	108.0868	107.65	107.76	11389326.0
2010-06-04 14:00:00	SPY	ETF	107.77	107.95	107.42	107.531	17741202.0
2010-06-04 14:30:00	SPY	ETF	107.54	107.71	106.83	106.94	30530615.0
2010-06-04 15:00:00	SPY	ETF	106.925	107.41	106.86	106.91	30937253.0
2010-06-04 15:30:00	SPY	ETF	106.91	107.64	106.465	107.01	60808458.0
2010-06-04 16:00:00	SPY	ETF	107.0	110.7281	106.7899	107.13	22267401.0
2010-06-04 16:30:00	SPY	ETF	107.13	108.0572	106.9339	107.21	17140597.0
2010-06-04 17:00:00	SPY	ETF	107.2	107.28	107.2	107.26	1324174.0
2010-06-04 17:30:00	SPY	ETF	107.23	110.7281	106.94	107.25	13456841.0
2010-06-04 18:00:00	SPY	ETF	107.25	107.27	107.04	107.11	1745298.0
2010-06-04 18:30:00	SPY	ETF	107.11	110.7281	107.11	107.13	1065280.0
2010-06-04 19:00:00	SPY	ETF	107.12	107.2	107.11	107.18	43824.0
2010-06-04 19:30:00	SPY	ETF	107.19	107.25	107.13	107.22	57310.0
2010-06-04 05:00:00	QQQ	ETF	46.84	46.84	46.84	46.84	100.0
2010-06-04 05:30:00	QQQ	ETF	46.89	46.89	46.89	46.89	100.0
2010-06-04 06:30:00	QQQ	ETF	46.71	46.73	46.7	46.73	5352.0
2010-06-04 07:00:00	QQQ	ETF	46.6	46.6	46.32	46.36	2256298.0
2010-06-04 07:30:00	QQQ	ETF	46.36	46.38	46.18	46.25	1461206.0
2010-06-04 08:00:00	QQQ	ETF	46.25	46.7	46.25	46.38	2765984.0
2010-06-04 08:30:00	QQQ	ETF	46.38	46.38	45.63	45.74	5295141.0
2010-06-04 09:00:00	QQQ	ETF	45.75	45.77	45.58	45.71	1577635.0
2010-06-04 09:30:00	QQQ	ETF	45.71	46.2	45.67	46.12	16056757.0
2010-06-04 10:00:00	QQQ	ETF	46.119	46.29	46.0	46.23	8217282.0
2010-06-04 10:30:00	QQQ	ETF	46.23	46.27	46.02	46.03	5060872.0
2010-06-04 11:00:00	QQQ	ETF	46.03	46.12	45.82	45.8395	4412874.0
2010-06-04 11:30:00	QQQ	ETF	45.83	45.99	45.79	45.91	3145557.0
2010-06-04 12:00:00	QQQ	ETF	45.9	45.9	45.66	45.76	3801058.0
2010-06-04 12:30:00	QQQ	ETF	45.75	45.8	45.63	45.79	2980843.0
2010-06-04 13:00:00	QQQ	ETF	45.79	45.8	45.5	45.58	4265982.0
2010-06-04 13:30:00	QQQ	ETF	45.58	45.59	45.39	45.4299	3105308.0
2010-06-04 14:00:00	QQQ	ETF	45.43	45.53	45.32	45.37	5035926.0

> showing 50 of 8,763 rows — these rows as CSV

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