PREVIEW / etf_30min / 2010-01-27

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-01-27.parquet
  size:    251 KB
  rows:    8,247

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-01-27 04:00:00	SPY	ETF	108.97	109.09	108.82	109.09	13565.0
2010-01-27 04:30:00	SPY	ETF	108.98	108.98	108.91	108.96	700.0
2010-01-27 05:00:00	SPY	ETF	109.12	109.26	109.09	109.26	1800.0
2010-01-27 05:30:00	SPY	ETF	109.27	109.27	109.12	109.12	21022.0
2010-01-27 06:00:00	SPY	ETF	109.15	109.25	109.15	109.25	11055.0
2010-01-27 06:30:00	SPY	ETF	109.46	109.55	109.42	109.42	19780.0
2010-01-27 07:00:00	SPY	ETF	109.49	109.57	109.37	109.47	615266.0
2010-01-27 07:30:00	SPY	ETF	109.47	109.55	109.32	109.35	235463.0
2010-01-27 08:00:00	SPY	ETF	109.45	109.55	108.87	109.35	2076313.0
2010-01-27 08:30:00	SPY	ETF	109.35	109.4	109.22	109.22	686033.0
2010-01-27 09:00:00	SPY	ETF	109.22	109.22	108.83	109.17	5606686.0
2010-01-27 09:30:00	SPY	ETF	109.17	109.51	108.94	109.23	31703828.0
2010-01-27 10:00:00	SPY	ETF	109.23	109.31	108.58	109.01	25575540.0
2010-01-27 10:30:00	SPY	ETF	109.01	109.31	108.68	109.25	19364601.0
2010-01-27 11:00:00	SPY	ETF	109.25	109.2857	108.89	109.11	16332473.0
2010-01-27 11:30:00	SPY	ETF	109.11	109.23	108.95	109.1	9737274.0
2010-01-27 12:00:00	SPY	ETF	109.1	109.18	108.89	109.01	6518407.0
2010-01-27 12:30:00	SPY	ETF	109.0105	109.06	108.7	108.82	9656637.0
2010-01-27 13:00:00	SPY	ETF	108.82	108.92	108.64	108.68	9475025.0
2010-01-27 13:30:00	SPY	ETF	108.68	108.88	108.66	108.81	7407312.0
2010-01-27 14:00:00	SPY	ETF	108.81	109.11	108.33	108.83	29756172.0
2010-01-27 14:30:00	SPY	ETF	108.84	109.65	108.74	109.54	25497259.0
2010-01-27 15:00:00	SPY	ETF	109.54	109.68	108.99	109.63	21043857.0
2010-01-27 15:30:00	SPY	ETF	109.65	110.08	108.8	109.83	32729217.0
2010-01-27 16:00:00	SPY	ETF	109.84	110.0	108.69	109.9	7557929.0
2010-01-27 16:30:00	SPY	ETF	109.91	110.01	109.2466	109.97	8424287.0
2010-01-27 17:00:00	SPY	ETF	109.98	110.03	109.8099	110.03	110372.0
2010-01-27 17:30:00	SPY	ETF	110.03	110.03	109.97	109.99	11340.0
2010-01-27 18:00:00	SPY	ETF	109.98	110.18	109.98	110.16	79459.0
2010-01-27 18:30:00	SPY	ETF	110.16	110.23	110.07	110.11	131157.0
2010-01-27 19:00:00	SPY	ETF	110.11	110.18	110.08	110.18	50451.0
2010-01-27 19:30:00	SPY	ETF	110.15	110.18	110.03	110.11	120250.0
2010-01-27 04:00:00	QQQ	ETF	44.08	44.16	44.08	44.16	6600.0
2010-01-27 05:30:00	QQQ	ETF	44.25	44.25	44.25	44.25	100.0
2010-01-27 06:30:00	QQQ	ETF	44.36	44.37	44.33	44.33	20244.0
2010-01-27 07:00:00	QQQ	ETF	44.34	44.38	44.32	44.36	50836.0
2010-01-27 07:30:00	QQQ	ETF	44.35	44.35	44.27	44.29	200621.0
2010-01-27 08:00:00	QQQ	ETF	44.28	44.31	44.24	44.29	389523.0
2010-01-27 08:30:00	QQQ	ETF	44.3	44.32	44.24	44.24	371901.0
2010-01-27 09:00:00	QQQ	ETF	44.25	44.29	44.15	44.28	4868799.0
2010-01-27 09:30:00	QQQ	ETF	44.29	44.55	44.22	44.43	18047414.0
2010-01-27 10:00:00	QQQ	ETF	44.43	44.46	44.11	44.3262	15174203.0
2010-01-27 10:30:00	QQQ	ETF	44.33	44.44	44.16	44.4	11078276.0
2010-01-27 11:00:00	QQQ	ETF	44.41	44.44	44.26	44.36	4706902.0
2010-01-27 11:30:00	QQQ	ETF	44.37	44.39	44.28	44.32	3655238.0
2010-01-27 12:00:00	QQQ	ETF	44.32	44.4	44.25	44.38	2977575.0
2010-01-27 12:30:00	QQQ	ETF	44.37	44.39	44.26	44.281	4595027.0
2010-01-27 13:00:00	QQQ	ETF	44.28	44.34	44.01	44.0701	9147137.0
2010-01-27 13:30:00	QQQ	ETF	44.08	44.23	44.075	44.1962	2852495.0
2010-01-27 14:00:00	QQQ	ETF	44.19	44.53	44.13	44.31	16880055.0

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

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