PREVIEW / etf_30min / 2009-05-18

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-05-18.parquet
  size:    218 KB
  rows:    7,231

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-18 04:00:00	SPY	ETF	88.65	88.7	88.6	88.6	2200.0
2009-05-18 04:30:00	SPY	ETF	88.55	88.76	88.55	88.76	1100.0
2009-05-18 05:00:00	SPY	ETF	88.93	89.1	88.9	89.1	16100.0
2009-05-18 05:30:00	SPY	ETF	89.25	89.35	89.19	89.19	11000.0
2009-05-18 06:00:00	SPY	ETF	89.19	89.25	89.08	89.08	9325.0
2009-05-18 06:30:00	SPY	ETF	89.1	89.13	89.0	89.13	62900.0
2009-05-18 07:00:00	SPY	ETF	89.11	89.35	89.1	89.26	199978.0
2009-05-18 07:30:00	SPY	ETF	89.29	89.64	89.2	89.48	969243.0
2009-05-18 08:00:00	SPY	ETF	89.47	89.61	88.76	89.41	2593713.0
2009-05-18 08:30:00	SPY	ETF	89.41	89.5	89.32	89.46	879209.0
2009-05-18 09:00:00	SPY	ETF	89.46	89.65	88.4925	89.56	950671.0
2009-05-18 09:30:00	SPY	ETF	89.55	89.88	89.41	89.62	26702348.0
2009-05-18 10:00:00	SPY	ETF	89.62	89.93	89.37	89.82	16491410.0
2009-05-18 10:30:00	SPY	ETF	89.83	90.21	89.76	90.14	19239819.0
2009-05-18 11:00:00	SPY	ETF	90.15	90.23	90.02	90.18	12351650.0
2009-05-18 11:30:00	SPY	ETF	90.18	90.3	90.0091	90.09	12488278.0
2009-05-18 12:00:00	SPY	ETF	90.09	90.33	90.07	90.3	8939685.0
2009-05-18 12:30:00	SPY	ETF	90.3	90.63	90.28	90.56	11956675.0
2009-05-18 13:00:00	SPY	ETF	90.57	90.605	90.29	90.42	9311169.0
2009-05-18 13:30:00	SPY	ETF	90.42	90.46	89.77	90.34	8247216.0
2009-05-18 14:00:00	SPY	ETF	90.34	90.53	90.19	90.27	9923430.0
2009-05-18 14:30:00	SPY	ETF	90.27	90.85	90.26	90.8	14363872.0
2009-05-18 15:00:00	SPY	ETF	90.8099	90.83	90.6	90.65	12354177.0
2009-05-18 15:30:00	SPY	ETF	90.65	91.34	90.55	91.25	31574766.0
2009-05-18 16:00:00	SPY	ETF	91.26	91.33	90.2	91.2	12092037.0
2009-05-18 16:30:00	SPY	ETF	91.22	91.25	91.2	91.21	5587897.0
2009-05-18 17:00:00	SPY	ETF	91.23	91.23	91.14	91.18	178593.0
2009-05-18 17:30:00	SPY	ETF	90.2281	91.24	90.2281	91.22	85546.0
2009-05-18 18:00:00	SPY	ETF	91.22	91.2806	89.38	91.2506	679959.0
2009-05-18 18:30:00	SPY	ETF	91.21	91.25	91.2	91.22	20000.0
2009-05-18 19:00:00	SPY	ETF	91.24	91.25	91.2	91.24	16568.0
2009-05-18 19:30:00	SPY	ETF	91.22	91.26	91.18	91.25	58022.0
2009-05-18 04:00:00	QQQ	ETF	33.3	33.3	33.3	33.3	100.0
2009-05-18 04:30:00	QQQ	ETF	33.26	33.26	33.26	33.26	100.0
2009-05-18 05:30:00	QQQ	ETF	33.5	33.52	33.5	33.5	400.0
2009-05-18 06:00:00	QQQ	ETF	33.47	33.48	33.47	33.48	200.0
2009-05-18 06:30:00	QQQ	ETF	33.43	33.43	33.43	33.43	100.0
2009-05-18 07:00:00	QQQ	ETF	33.48	33.59	33.47	33.57	93600.0
2009-05-18 07:30:00	QQQ	ETF	33.55	33.67	33.55	33.63	504847.0
2009-05-18 08:00:00	QQQ	ETF	33.62	33.65	33.52	33.57	1277674.0
2009-05-18 08:30:00	QQQ	ETF	33.56	33.58	33.52	33.56	339534.0
2009-05-18 09:00:00	QQQ	ETF	33.56	33.61	33.54	33.59	389888.0
2009-05-18 09:30:00	QQQ	ETF	33.59	33.73	33.51	33.59	14367571.0
2009-05-18 10:00:00	QQQ	ETF	33.58	33.62	33.3901	33.55	11249814.0
2009-05-18 10:30:00	QQQ	ETF	33.56	33.77	33.53	33.7386	6582244.0
2009-05-18 11:00:00	QQQ	ETF	33.73	33.76	33.6	33.691	5249272.0
2009-05-18 11:30:00	QQQ	ETF	33.7	33.77	33.68	33.68	3917956.0
2009-05-18 12:00:00	QQQ	ETF	33.69	33.89	33.68	33.8703	4553783.0
2009-05-18 12:30:00	QQQ	ETF	33.875	34.02	33.86	33.97	7802222.0
2009-05-18 13:00:00	QQQ	ETF	33.96	33.98	33.88	33.94	4029506.0

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

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