PREVIEW / etf_30min / 2009-12-10

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-12-10.parquet
  size:    226 KB
  rows:    7,691

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-12-10 04:30:00	SPY	ETF	110.1	110.2	110.07	110.11	1600.0
2009-12-10 05:00:00	SPY	ETF	110.28	110.39	110.28	110.39	700.0
2009-12-10 05:30:00	SPY	ETF	110.47	110.47	110.34	110.34	2602.0
2009-12-10 06:00:00	SPY	ETF	110.43	110.44	110.4	110.4	6000.0
2009-12-10 06:30:00	SPY	ETF	110.45	110.48	110.44	110.44	4424.0
2009-12-10 07:00:00	SPY	ETF	110.49	110.65	110.43	110.6	108905.0
2009-12-10 07:30:00	SPY	ETF	110.6	110.61	110.54	110.55	86111.0
2009-12-10 08:00:00	SPY	ETF	110.48	110.91	110.48	110.82	982881.0
2009-12-10 08:30:00	SPY	ETF	110.81	110.94	110.52	110.73	1463223.0
2009-12-10 09:00:00	SPY	ETF	110.74	110.76	110.64	110.69	880976.0
2009-12-10 09:30:00	SPY	ETF	110.7	111.12	110.68	110.81	18683474.0
2009-12-10 10:00:00	SPY	ETF	110.82	110.8799	110.5	110.81	12687271.0
2009-12-10 10:30:00	SPY	ETF	110.81	110.94	110.71	110.829	7353169.0
2009-12-10 11:00:00	SPY	ETF	110.83	111.04	110.75	110.85	8643377.0
2009-12-10 11:30:00	SPY	ETF	110.85	111.0	110.74	110.78	4603620.0
2009-12-10 12:00:00	SPY	ETF	110.78	110.97	110.71	110.75	5053850.0
2009-12-10 12:30:00	SPY	ETF	110.75	110.89	110.65	110.87	4462260.0
2009-12-10 13:00:00	SPY	ETF	110.87	110.88	110.56	110.64	12166182.0
2009-12-10 13:30:00	SPY	ETF	110.64	110.85	110.61	110.83	3711473.0
2009-12-10 14:00:00	SPY	ETF	110.82	110.99	110.75	110.95	5802575.0
2009-12-10 14:30:00	SPY	ETF	110.95	110.98	110.81	110.82	4648830.0
2009-12-10 15:00:00	SPY	ETF	110.82	110.83	110.45	110.54	12624647.0
2009-12-10 15:30:00	SPY	ETF	110.5383	110.75	110.49	110.65	13531697.0
2009-12-10 16:00:00	SPY	ETF	110.65	111.03	110.064	110.75	14786850.0
2009-12-10 16:30:00	SPY	ETF	110.75	110.85	110.72	110.83	264804.0
2009-12-10 17:00:00	SPY	ETF	110.84	110.88	110.82	110.86	146885.0
2009-12-10 17:30:00	SPY	ETF	110.81	110.85	110.81	110.82	8686.0
2009-12-10 18:00:00	SPY	ETF	110.83	110.83	110.8	110.81	8790.0
2009-12-10 18:30:00	SPY	ETF	110.81	110.86	110.8	110.86	15563.0
2009-12-10 19:00:00	SPY	ETF	110.89	110.9	110.87	110.89	15331.0
2009-12-10 19:30:00	SPY	ETF	110.89	110.89	110.78	110.79	17167.0
2009-12-10 06:00:00	QQQ	ETF	44.24	44.25	44.24	44.25	300.0
2009-12-10 06:30:00	QQQ	ETF	44.3	44.3	44.3	44.3	150.0
2009-12-10 07:00:00	QQQ	ETF	44.3	44.35	44.29	44.35	116000.0
2009-12-10 07:30:00	QQQ	ETF	44.35	44.37	44.35	44.36	354550.0
2009-12-10 08:00:00	QQQ	ETF	44.05	44.42	44.05	44.38	1100351.0
2009-12-10 08:30:00	QQQ	ETF	44.35	44.43	44.28	44.28	560642.0
2009-12-10 09:00:00	QQQ	ETF	44.28	44.29	44.21	44.25	1208057.0
2009-12-10 09:30:00	QQQ	ETF	44.25	44.54	44.24	44.38	12787676.0
2009-12-10 10:00:00	QQQ	ETF	44.38	44.495	44.32	44.4505	6924231.0
2009-12-10 10:30:00	QQQ	ETF	44.46	44.49	44.38	44.431	4166195.0
2009-12-10 11:00:00	QQQ	ETF	44.43	44.51	44.41	44.46	3830374.0
2009-12-10 11:30:00	QQQ	ETF	44.46	44.5	44.4	44.42	3839187.0
2009-12-10 12:00:00	QQQ	ETF	44.42	44.48	44.39	44.42	1961762.0
2009-12-10 12:30:00	QQQ	ETF	44.41	44.49	44.38	44.4899	2012367.0
2009-12-10 13:00:00	QQQ	ETF	44.49	44.49	44.3	44.36	7439467.0
2009-12-10 13:30:00	QQQ	ETF	44.3501	44.43	44.35	44.41	1530442.0
2009-12-10 14:00:00	QQQ	ETF	44.41	44.47	44.38	44.45	2134828.0
2009-12-10 14:30:00	QQQ	ETF	44.445	44.47	44.38	44.41	2684860.0
2009-12-10 15:00:00	QQQ	ETF	44.4101	44.45	44.28	44.29	5438346.0

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

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