PREVIEW / etf_30min / 2009-05-27

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-05-27.parquet
  size:    221 KB
  rows:    7,287

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-27 04:00:00	SPY	ETF	91.44	91.57	91.44	91.47	10650.0
2009-05-27 04:30:00	SPY	ETF	91.43	91.55	91.39	91.39	4200.0
2009-05-27 05:00:00	SPY	ETF	91.39	91.39	91.24	91.24	2500.0
2009-05-27 05:30:00	SPY	ETF	91.52	91.75	91.52	91.64	1100.0
2009-05-27 06:00:00	SPY	ETF	91.72	91.79	91.62	91.62	9347.0
2009-05-27 06:30:00	SPY	ETF	91.62	91.74	91.49	91.72	11100.0
2009-05-27 07:00:00	SPY	ETF	91.6	91.62	91.43	91.45	60245.0
2009-05-27 07:30:00	SPY	ETF	91.43	91.52	91.29	91.3	223615.0
2009-05-27 08:00:00	SPY	ETF	91.28	91.46	91.02	91.2	1266504.0
2009-05-27 08:30:00	SPY	ETF	91.21	91.56	91.17	91.34	1344576.0
2009-05-27 09:00:00	SPY	ETF	91.34	91.45	91.18	91.45	1738045.0
2009-05-27 09:30:00	SPY	ETF	91.44	91.52	91.05	91.43	19337836.0
2009-05-27 10:00:00	SPY	ETF	91.44	91.75	90.93	91.37	29710240.0
2009-05-27 10:30:00	SPY	ETF	91.38	91.54	91.12	91.47	16894079.0
2009-05-27 11:00:00	SPY	ETF	91.47	91.48	91.13	91.38	13161918.0
2009-05-27 11:30:00	SPY	ETF	91.38	91.65	91.28	91.5	11729008.0
2009-05-27 12:00:00	SPY	ETF	91.5	91.74	91.49	91.55	10088079.0
2009-05-27 12:30:00	SPY	ETF	91.55	91.58	91.2	91.28	7864987.0
2009-05-27 13:00:00	SPY	ETF	91.29	91.53	91.26	91.39	7627795.0
2009-05-27 13:30:00	SPY	ETF	91.3874	91.39	90.34	90.6	19853939.0
2009-05-27 14:00:00	SPY	ETF	90.6	90.61	90.12	90.36	17503131.0
2009-05-27 14:30:00	SPY	ETF	90.36	90.68	90.22	90.39	13158506.0
2009-05-27 15:00:00	SPY	ETF	90.39	90.66	89.66	89.76	23133492.0
2009-05-27 15:30:00	SPY	ETF	89.755	90.4699	89.53	89.68	34176117.0
2009-05-27 16:00:00	SPY	ETF	89.69	91.3807	89.55	89.67	9752796.0
2009-05-27 16:30:00	SPY	ETF	89.69	89.72	89.56	89.57	5080980.0
2009-05-27 17:00:00	SPY	ETF	89.6	91.3807	89.55	89.68	1050338.0
2009-05-27 17:30:00	SPY	ETF	89.68	89.7	89.64	89.67	36675.0
2009-05-27 18:00:00	SPY	ETF	89.67	89.68	89.37	89.45	108502.0
2009-05-27 18:30:00	SPY	ETF	89.45	89.45	89.35	89.35	97322.0
2009-05-27 19:00:00	SPY	ETF	89.36	89.41	89.35	89.4	21380.0
2009-05-27 19:30:00	SPY	ETF	89.41	89.49	89.39	89.45	93463.0
2009-05-27 05:00:00	QQQ	ETF	34.75	34.75	34.75	34.75	2000.0
2009-05-27 05:30:00	QQQ	ETF	34.78	34.78	34.78	34.78	200.0
2009-05-27 06:30:00	QQQ	ETF	34.73	34.77	34.69	34.77	90000.0
2009-05-27 07:00:00	QQQ	ETF	34.78	34.78	34.7	34.72	96249.0
2009-05-27 07:30:00	QQQ	ETF	34.71	34.75	34.68	34.69	130800.0
2009-05-27 08:00:00	QQQ	ETF	34.69	34.7	34.59	34.67	471132.0
2009-05-27 08:30:00	QQQ	ETF	34.67	34.8	34.64	34.69	315539.0
2009-05-27 09:00:00	QQQ	ETF	34.68	34.73	34.63	34.69	762099.0
2009-05-27 09:30:00	QQQ	ETF	34.69	34.98	34.59	34.92	9425515.0
2009-05-27 10:00:00	QQQ	ETF	34.92	35.1	34.77	35.03	12869971.0
2009-05-27 10:30:00	QQQ	ETF	35.04	35.17	34.97	35.14	7275031.0
2009-05-27 11:00:00	QQQ	ETF	35.15	35.15	35.01	35.08	5963488.0
2009-05-27 11:30:00	QQQ	ETF	35.09	35.15	35.05	35.11	5980871.0
2009-05-27 12:00:00	QQQ	ETF	35.1199	35.19	35.07	35.1	5291505.0
2009-05-27 12:30:00	QQQ	ETF	35.1	35.11	34.96	34.9989	4607564.0
2009-05-27 13:00:00	QQQ	ETF	34.99	35.1	34.98	35.0501	3392396.0
2009-05-27 13:30:00	QQQ	ETF	35.05	35.055	34.62	34.73	11338790.0
2009-05-27 14:00:00	QQQ	ETF	34.74	34.75	34.59	34.69	7920393.0

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

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