PREVIEW / etf_30min / 2010-05-28

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-05-28.parquet
  size:    254 KB
  rows:    8,340

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-05-28 04:00:00	SPY	ETF	110.59	110.61	110.49	110.49	700.0
2010-05-28 04:30:00	SPY	ETF	110.75	110.88	110.75	110.88	950.0
2010-05-28 05:00:00	SPY	ETF	110.7	110.76	110.7	110.76	1323.0
2010-05-28 05:30:00	SPY	ETF	110.76	110.85	110.76	110.85	54100.0
2010-05-28 06:00:00	SPY	ETF	110.85	110.9	110.85	110.86	4200.0
2010-05-28 06:30:00	SPY	ETF	110.88	110.88	110.66	110.7	7600.0
2010-05-28 07:00:00	SPY	ETF	110.77	110.78	110.66	110.7	106975.0
2010-05-28 07:30:00	SPY	ETF	110.7	111.18	110.7	111.01	590776.0
2010-05-28 08:00:00	SPY	ETF	111.05	111.14	110.7	110.85	1408943.0
2010-05-28 08:30:00	SPY	ETF	110.82	110.9	110.61	110.7	1769813.0
2010-05-28 09:00:00	SPY	ETF	110.71	110.99	110.59	110.65	1875875.0
2010-05-28 09:30:00	SPY	ETF	110.64	110.68	109.92	110.4	32214931.0
2010-05-28 10:00:00	SPY	ETF	110.39	110.66	110.3	110.38	18678505.0
2010-05-28 10:30:00	SPY	ETF	110.33	110.724	109.8	110.02	21867277.0
2010-05-28 11:00:00	SPY	ETF	110.01	110.14	109.565	109.85	17707591.0
2010-05-28 11:30:00	SPY	ETF	109.84	110.25	109.79	110.07	12395259.0
2010-05-28 12:00:00	SPY	ETF	110.0699	110.33	109.97	110.25	7499801.0
2010-05-28 12:30:00	SPY	ETF	110.24	110.6693	108.97	109.53	45156893.0
2010-05-28 13:00:00	SPY	ETF	109.53	109.77	109.35	109.63	11653070.0
2010-05-28 13:30:00	SPY	ETF	109.622	109.7	109.15	109.2	9818895.0
2010-05-28 14:00:00	SPY	ETF	109.2	109.45	108.85	109.4	15875665.0
2010-05-28 14:30:00	SPY	ETF	109.41	110.16	109.31	109.84	17090250.0
2010-05-28 15:00:00	SPY	ETF	109.83	110.35	109.7	110.2681	15824787.0
2010-05-28 15:30:00	SPY	ETF	110.27	110.46	109.24	109.35	38359585.0
2010-05-28 16:00:00	SPY	ETF	109.39	110.7232	108.94	109.09	13871583.0
2010-05-28 16:30:00	SPY	ETF	109.09	109.09	108.96	109.01	2565085.0
2010-05-28 17:00:00	SPY	ETF	109.04	109.04	108.97	108.99	616905.0
2010-05-28 17:30:00	SPY	ETF	108.99	110.7235	108.91	108.98	1775299.0
2010-05-28 18:00:00	SPY	ETF	108.99	109.44	108.94	109.31	165881.0
2010-05-28 18:30:00	SPY	ETF	109.3	109.5	109.22	109.34	173661.0
2010-05-28 19:00:00	SPY	ETF	109.34	109.44	109.24	109.39	26425.0
2010-05-28 19:30:00	SPY	ETF	109.39	109.43	109.34	109.37	33436.0
2010-05-28 06:00:00	QQQ	ETF	45.98	45.98	45.98	45.98	700.0
2010-05-28 06:30:00	QQQ	ETF	45.92	45.92	45.9	45.9	522.0
2010-05-28 07:00:00	QQQ	ETF	45.97	45.97	45.93	45.96	55217.0
2010-05-28 07:30:00	QQQ	ETF	45.96	46.17	45.96	46.08	536375.0
2010-05-28 08:00:00	QQQ	ETF	46.08	46.15	46.03	46.06	423640.0
2010-05-28 08:30:00	QQQ	ETF	46.05	46.06	45.92	45.94	577376.0
2010-05-28 09:00:00	QQQ	ETF	45.94	46.0	45.9	45.94	466276.0
2010-05-28 09:30:00	QQQ	ETF	45.94	45.98	45.65	45.85	13511384.0
2010-05-28 10:00:00	QQQ	ETF	45.85	45.98	45.81	45.83	7547794.0
2010-05-28 10:30:00	QQQ	ETF	45.83	45.95	45.58	45.67	8960802.0
2010-05-28 11:00:00	QQQ	ETF	45.66	45.71	45.38	45.58	5792844.0
2010-05-28 11:30:00	QQQ	ETF	45.57	45.68	45.51	45.61	6501964.0
2010-05-28 12:00:00	QQQ	ETF	45.62	45.76	45.56	45.7499	3009357.0
2010-05-28 12:30:00	QQQ	ETF	45.742	45.78	45.22	45.42	25328150.0
2010-05-28 13:00:00	QQQ	ETF	45.42	45.52	45.36	45.4604	7173071.0
2010-05-28 13:30:00	QQQ	ETF	45.465	45.49	45.31	45.355	4866928.0
2010-05-28 14:00:00	QQQ	ETF	45.34	45.47	45.2	45.4699	4854672.0
2010-05-28 14:30:00	QQQ	ETF	45.47	45.8	45.42	45.705	5433929.0

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

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