PREVIEW / etf_30min / 2009-05-04

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-05-04.parquet
  size:    223 KB
  rows:    7,457

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-05-04 04:00:00	SPY	ETF	88.64	88.66	88.63	88.66	5400.0
2009-05-04 04:30:00	SPY	ETF	88.57	88.62	88.51	88.57	3900.0
2009-05-04 05:00:00	SPY	ETF	88.74	88.8	88.74	88.8	400.0
2009-05-04 05:30:00	SPY	ETF	88.78	88.8	88.73	88.73	41630.0
2009-05-04 06:00:00	SPY	ETF	88.73	88.73	88.62	88.62	6200.0
2009-05-04 06:30:00	SPY	ETF	88.62	88.62	88.49	88.49	24578.0
2009-05-04 07:00:00	SPY	ETF	88.49	88.55	88.26	88.34	300770.0
2009-05-04 07:30:00	SPY	ETF	88.31	88.53	88.29	88.48	181424.0
2009-05-04 08:00:00	SPY	ETF	88.48	88.93	88.31	88.36	1781732.0
2009-05-04 08:30:00	SPY	ETF	88.36	88.54	88.25	88.5	1859895.0
2009-05-04 09:00:00	SPY	ETF	88.51	88.58	88.4	88.55	1289189.0
2009-05-04 09:30:00	SPY	ETF	88.55	89.18	88.38	89.14	31532251.0
2009-05-04 10:00:00	SPY	ETF	89.14	89.9	89.13	89.76	31674518.0
2009-05-04 10:30:00	SPY	ETF	89.7599	89.77	89.55	89.61	12159810.0
2009-05-04 11:00:00	SPY	ETF	89.62	90.06	89.615	89.85	19208329.0
2009-05-04 11:30:00	SPY	ETF	89.851	89.93	89.57	89.67	9737969.0
2009-05-04 12:00:00	SPY	ETF	89.6799	89.95	89.35	89.45	15254120.0
2009-05-04 12:30:00	SPY	ETF	89.46	89.8	89.41	89.65	12724385.0
2009-05-04 13:00:00	SPY	ETF	89.65	89.9	89.6	89.8205	9109762.0
2009-05-04 13:30:00	SPY	ETF	89.8299	90.12	89.82	90.0294	12508645.0
2009-05-04 14:00:00	SPY	ETF	90.0294	90.25	88.6256	90.22	17682300.0
2009-05-04 14:30:00	SPY	ETF	90.22	90.25	89.96	90.06	19374806.0
2009-05-04 15:00:00	SPY	ETF	90.06	90.78	90.05	90.19	20140595.0
2009-05-04 15:30:00	SPY	ETF	90.2	90.93	89.62	90.93	43923414.0
2009-05-04 16:00:00	SPY	ETF	90.9	90.97	89.3918	90.72	16009816.0
2009-05-04 16:30:00	SPY	ETF	90.73	90.8	90.71	90.78	3292174.0
2009-05-04 17:00:00	SPY	ETF	90.77	90.8	90.71	90.75	129052.0
2009-05-04 17:30:00	SPY	ETF	90.75	90.83	90.73	90.81	122637.0
2009-05-04 18:00:00	SPY	ETF	90.8	90.81	90.73	90.78	425789.0
2009-05-04 18:30:00	SPY	ETF	90.79	90.82	90.74	90.82	42827.0
2009-05-04 19:00:00	SPY	ETF	90.82	90.84	90.8	90.82	16589.0
2009-05-04 19:30:00	SPY	ETF	90.83	90.86	90.7	90.73	98001.0
2009-05-04 04:00:00	QQQ	ETF	34.71	34.71	34.71	34.71	1000.0
2009-05-04 05:00:00	QQQ	ETF	34.71	34.75	34.71	34.75	230.0
2009-05-04 05:30:00	QQQ	ETF	34.76	34.79	34.7	34.7	91000.0
2009-05-04 06:00:00	QQQ	ETF	34.7	34.7	34.68	34.68	40670.0
2009-05-04 06:30:00	QQQ	ETF	34.67	34.67	34.63	34.63	10200.0
2009-05-04 07:00:00	QQQ	ETF	34.63	34.75	34.59	34.64	561285.0
2009-05-04 07:30:00	QQQ	ETF	34.63	34.68	34.61	34.68	115235.0
2009-05-04 08:00:00	QQQ	ETF	34.64	34.7	34.58	34.6	743223.0
2009-05-04 08:30:00	QQQ	ETF	34.61	34.68	34.58	34.67	677285.0
2009-05-04 09:00:00	QQQ	ETF	34.67	34.7	34.62	34.67	841365.0
2009-05-04 09:30:00	QQQ	ETF	34.67	34.74	34.52	34.67	14049312.0
2009-05-04 10:00:00	QQQ	ETF	34.67	35.02	34.625	34.95	15100977.0
2009-05-04 10:30:00	QQQ	ETF	34.96	34.96	34.83	34.8499	6638070.0
2009-05-04 11:00:00	QQQ	ETF	34.85	34.99	34.85	34.93	7522372.0
2009-05-04 11:30:00	QQQ	ETF	34.9279	34.96	34.82	34.855	4874463.0
2009-05-04 12:00:00	QQQ	ETF	34.868	34.97	34.77	34.82	7672511.0
2009-05-04 12:30:00	QQQ	ETF	34.83	34.93	34.815	34.88	5149701.0
2009-05-04 13:00:00	QQQ	ETF	34.87	34.96	34.84	34.9401	5185548.0

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

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