PREVIEW / etf_30min / 2009-05-15

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-05-15.parquet
  size:    213 KB
  rows:    7,031

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-15 04:00:00	SPY	ETF	89.5	89.54	89.5	89.53	3400.0
2009-05-15 04:30:00	SPY	ETF	89.5	89.5	89.39	89.39	700.0
2009-05-15 05:00:00	SPY	ETF	89.54	89.62	89.48	89.53	15500.0
2009-05-15 05:30:00	SPY	ETF	89.43	89.58	89.43	89.44	5911.0
2009-05-15 06:00:00	SPY	ETF	89.44	89.44	89.11	89.12	40300.0
2009-05-15 06:30:00	SPY	ETF	89.14	89.16	89.03	89.1	32865.0
2009-05-15 07:00:00	SPY	ETF	89.04	89.06	88.68	88.82	1683788.0
2009-05-15 07:30:00	SPY	ETF	88.84	88.95	88.8	88.8	253605.0
2009-05-15 08:00:00	SPY	ETF	88.8	89.45	88.72	88.85	2964292.0
2009-05-15 08:30:00	SPY	ETF	88.83	89.22	88.69	89.1	1953531.0
2009-05-15 09:00:00	SPY	ETF	89.12	89.44	89.03	89.35	2711354.0
2009-05-15 09:30:00	SPY	ETF	89.37	89.85	89.12	89.43	28599640.0
2009-05-15 10:00:00	SPY	ETF	89.43	89.6	89.09	89.53	20292095.0
2009-05-15 10:30:00	SPY	ETF	89.53	90.0	89.2	89.7	17662521.0
2009-05-15 11:00:00	SPY	ETF	89.7	89.81	89.44	89.54	11478939.0
2009-05-15 11:30:00	SPY	ETF	89.54	89.56	88.75	88.77	15888354.0
2009-05-15 12:00:00	SPY	ETF	88.77	88.96	88.69	88.88	13853262.0
2009-05-15 12:30:00	SPY	ETF	88.88	88.94	88.59	88.67	9596003.0
2009-05-15 13:00:00	SPY	ETF	88.67	88.88	88.6	88.635	10064156.0
2009-05-15 13:30:00	SPY	ETF	88.63	88.74	88.51	88.65	8907832.0
2009-05-15 14:00:00	SPY	ETF	88.64	88.84	88.5	88.69	9915811.0
2009-05-15 14:30:00	SPY	ETF	88.68	88.71	88.26	88.39	19211776.0
2009-05-15 15:00:00	SPY	ETF	88.3896	88.75	88.15	88.7	21386786.0
2009-05-15 15:30:00	SPY	ETF	88.69	88.76	88.41	88.7	31722185.0
2009-05-15 16:00:00	SPY	ETF	88.69	88.85	88.3	88.76	17036124.0
2009-05-15 16:30:00	SPY	ETF	88.77	89.5808	88.74	88.9	6605412.0
2009-05-15 17:00:00	SPY	ETF	88.9	88.95	88.89	88.91	56308.0
2009-05-15 17:30:00	SPY	ETF	88.91	88.94	88.88	88.91	31200.0
2009-05-15 18:00:00	SPY	ETF	88.89	88.94	88.84	88.84	21506.0
2009-05-15 18:30:00	SPY	ETF	88.86	88.87	88.83	88.83	3450.0
2009-05-15 19:00:00	SPY	ETF	88.83	88.88	88.82	88.86	15905.0
2009-05-15 19:30:00	SPY	ETF	88.87	88.9	88.84	88.85	20263.0
2009-05-15 04:30:00	QQQ	ETF	33.39	33.39	33.39	33.39	2000.0
2009-05-15 05:30:00	QQQ	ETF	33.42	33.42	33.42	33.42	100.0
2009-05-15 06:00:00	QQQ	ETF	33.3	33.3	33.26	33.26	27000.0
2009-05-15 06:30:00	QQQ	ETF	33.23	33.23	33.19	33.19	8513.0
2009-05-15 07:00:00	QQQ	ETF	33.19	33.19	33.04	33.09	638630.0
2009-05-15 07:30:00	QQQ	ETF	33.09	33.14	33.07	33.09	634783.0
2009-05-15 08:00:00	QQQ	ETF	33.09	33.15	33.05	33.09	2687710.0
2009-05-15 08:30:00	QQQ	ETF	33.09	33.25	33.06	33.22	450932.0
2009-05-15 09:00:00	QQQ	ETF	33.22	33.36	33.19	33.35	964923.0
2009-05-15 09:30:00	QQQ	ETF	33.35	33.68	33.23	33.6	17965365.0
2009-05-15 10:00:00	QQQ	ETF	33.61	33.75	33.52	33.7	9682446.0
2009-05-15 10:30:00	QQQ	ETF	33.7	33.82	33.68	33.76	7165110.0
2009-05-15 11:00:00	QQQ	ETF	33.75	33.78	33.67	33.7	6379633.0
2009-05-15 11:30:00	QQQ	ETF	33.708	33.72	33.45	33.45	8300675.0
2009-05-15 12:00:00	QQQ	ETF	33.45	33.55	33.4	33.52	5236856.0
2009-05-15 12:30:00	QQQ	ETF	33.515	33.5423	33.41	33.46	2849592.0
2009-05-15 13:00:00	QQQ	ETF	33.45	33.53	33.42	33.4399	5226118.0
2009-05-15 13:30:00	QQQ	ETF	33.43	33.46	33.36	33.42	4005849.0

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

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