PREVIEW / etf_30min / 2009-11-12

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-11-12.parquet
  size:    236 KB
  rows:    7,745

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
2009-11-12 04:00:00	SPY	ETF	109.57	109.58	109.45	109.45	2955.0
2009-11-12 04:30:00	SPY	ETF	109.45	109.6	109.45	109.57	1300.0
2009-11-12 05:00:00	SPY	ETF	109.78	109.78	109.78	109.78	2500.0
2009-11-12 05:30:00	SPY	ETF	109.88	109.88	109.87	109.88	1100.0
2009-11-12 06:00:00	SPY	ETF	109.79	109.79	109.79	109.79	1000.0
2009-11-12 06:30:00	SPY	ETF	109.77	109.77	109.65	109.65	2000.0
2009-11-12 07:00:00	SPY	ETF	109.74	109.92	109.55	109.58	285344.0
2009-11-12 07:30:00	SPY	ETF	109.58	109.69	109.47	109.67	457974.0
2009-11-12 08:00:00	SPY	ETF	109.67	109.88	109.38	109.88	1232073.0
2009-11-12 08:30:00	SPY	ETF	109.88	110.15	109.58	109.84	2344398.0
2009-11-12 09:00:00	SPY	ETF	109.84	110.15	109.8	109.99	531836.0
2009-11-12 09:30:00	SPY	ETF	110.0	110.55	109.65	110.4	21718250.0
2009-11-12 10:00:00	SPY	ETF	110.4	110.57	109.9	110.14	13955884.0
2009-11-12 10:30:00	SPY	ETF	110.13	110.37	109.94	110.0401	10262537.0
2009-11-12 11:00:00	SPY	ETF	110.04	110.06	109.5	109.6	18073321.0
2009-11-12 11:30:00	SPY	ETF	109.6	109.61	109.33	109.49	10373718.0
2009-11-12 12:00:00	SPY	ETF	109.48	109.63	109.46	109.53	4314540.0
2009-11-12 12:30:00	SPY	ETF	109.53	109.73	109.34	109.49	7981304.0
2009-11-12 13:00:00	SPY	ETF	109.49	109.51	109.18	109.37	9819670.0
2009-11-12 13:30:00	SPY	ETF	109.37	109.55	109.29	109.42	4650952.0
2009-11-12 14:00:00	SPY	ETF	109.42	109.58	109.32	109.37	4800238.0
2009-11-12 14:30:00	SPY	ETF	109.37	109.5	109.09	109.15	6499867.0
2009-11-12 15:00:00	SPY	ETF	109.14	109.21	108.94	109.02	9837842.0
2009-11-12 15:30:00	SPY	ETF	109.03	109.12	108.75	109.011	21101869.0
2009-11-12 16:00:00	SPY	ETF	109.02	110.24	108.95	109.15	7471044.0
2009-11-12 16:30:00	SPY	ETF	109.16	109.25	109.11	109.16	298903.0
2009-11-12 17:00:00	SPY	ETF	109.16	109.16	109.1	109.11	69950.0
2009-11-12 17:30:00	SPY	ETF	109.13	109.15	109.11	109.14	41022.0
2009-11-12 18:00:00	SPY	ETF	109.14	109.15	109.11	109.14	11700.0
2009-11-12 18:30:00	SPY	ETF	109.12	109.21	109.12	109.21	14925.0
2009-11-12 19:00:00	SPY	ETF	109.16	109.22	109.11	109.12	26335.0
2009-11-12 19:30:00	SPY	ETF	109.11	109.11	109.04	109.07	35423.0
2009-11-12 04:30:00	QQQ	ETF	43.69	43.69	43.69	43.69	100.0
2009-11-12 05:00:00	QQQ	ETF	43.74	43.8	43.74	43.8	4100.0
2009-11-12 05:30:00	QQQ	ETF	43.79	43.79	43.79	43.79	100.0
2009-11-12 06:00:00	QQQ	ETF	43.82	43.82	43.78	43.78	500.0
2009-11-12 06:30:00	QQQ	ETF	43.75	43.75	43.75	43.75	100.0
2009-11-12 07:00:00	QQQ	ETF	43.81	43.81	43.68	43.7	82500.0
2009-11-12 07:30:00	QQQ	ETF	43.68	43.72	43.65	43.71	124737.0
2009-11-12 08:00:00	QQQ	ETF	43.71	43.83	43.61	43.82	427254.0
2009-11-12 08:30:00	QQQ	ETF	43.82	43.86	43.74	43.81	613533.0
2009-11-12 09:00:00	QQQ	ETF	43.82	43.93	43.82	43.93	665688.0
2009-11-12 09:30:00	QQQ	ETF	43.93	44.15	43.81	44.1	15196229.0
2009-11-12 10:00:00	QQQ	ETF	44.11	44.16	43.88	43.995	10071325.0
2009-11-12 10:30:00	QQQ	ETF	43.98	44.07	43.92	43.95	6485533.0
2009-11-12 11:00:00	QQQ	ETF	43.94	43.98	43.76	43.82	9037977.0
2009-11-12 11:30:00	QQQ	ETF	43.83	43.83	43.73	43.79	5812823.0
2009-11-12 12:00:00	QQQ	ETF	43.7897	43.85	43.78	43.82	3054323.0
2009-11-12 12:30:00	QQQ	ETF	43.82	43.91	43.75	43.82	4756527.0
2009-11-12 13:00:00	QQQ	ETF	43.81	43.825	43.7	43.76	4465540.0

> showing 50 of 7,745 rows — these rows as CSV

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