PREVIEW / etf_30min / 2009-01-28

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-01-28.parquet
  size:    205 KB
  rows:    6,810

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-01-28 04:00:00	SPY	ETF	86.1	86.21	86.09	86.09	14987.0
2009-01-28 04:30:00	SPY	ETF	86.07	86.11	86.07	86.1	5177.0
2009-01-28 05:00:00	SPY	ETF	86.17	86.34	86.03	86.03	6500.0
2009-01-28 05:30:00	SPY	ETF	86.04	86.18	86.02	86.02	15400.0
2009-01-28 06:00:00	SPY	ETF	86.09	86.15	86.05	86.12	14423.0
2009-01-28 06:30:00	SPY	ETF	86.16	86.38	86.14	86.38	116310.0
2009-01-28 07:00:00	SPY	ETF	86.28	86.29	86.0	86.15	213152.0
2009-01-28 07:30:00	SPY	ETF	86.19	86.5	85.95	86.5	1315725.0
2009-01-28 08:00:00	SPY	ETF	86.5	86.78	86.01	86.01	3615345.0
2009-01-28 08:30:00	SPY	ETF	86.61	86.71	86.0	86.49	1578047.0
2009-01-28 09:00:00	SPY	ETF	86.5	86.52	86.26	86.39	1576480.0
2009-01-28 09:30:00	SPY	ETF	86.4	86.7	86.07	86.12	33889662.0
2009-01-28 10:00:00	SPY	ETF	86.12	86.46	86.07	86.46	16798794.0
2009-01-28 10:30:00	SPY	ETF	86.46	86.8525	86.35	86.72	21099068.0
2009-01-28 11:00:00	SPY	ETF	86.72	86.97	86.61	86.77	23488922.0
2009-01-28 11:30:00	SPY	ETF	86.78	86.88	86.46	86.62	12165281.0
2009-01-28 12:00:00	SPY	ETF	86.62	86.87	86.58	86.85	8485868.0
2009-01-28 12:30:00	SPY	ETF	86.85	86.9	86.74	86.761	6386733.0
2009-01-28 13:00:00	SPY	ETF	86.76	87.26	86.65	87.22	14138023.0
2009-01-28 13:30:00	SPY	ETF	87.22	87.59	87.21	87.25	15530906.0
2009-01-28 14:00:00	SPY	ETF	87.255	87.95	87.18	87.43	39094276.0
2009-01-28 14:30:00	SPY	ETF	87.44	87.62	86.98	87.58	34411132.0
2009-01-28 15:00:00	SPY	ETF	87.58	87.73	86.53	86.7	41173755.0
2009-01-28 15:30:00	SPY	ETF	86.7	87.52	86.58	87.43	41036980.0
2009-01-28 16:00:00	SPY	ETF	87.42	87.64	86.7	87.54	10641574.0
2009-01-28 16:30:00	SPY	ETF	87.49	87.54	87.39	87.46	1479478.0
2009-01-28 17:00:00	SPY	ETF	87.45	87.53	87.44	87.45	88712.0
2009-01-28 17:30:00	SPY	ETF	87.47	87.54	87.38	87.42	112461.0
2009-01-28 18:00:00	SPY	ETF	87.43	87.52	87.39	87.39	109076.0
2009-01-28 18:30:00	SPY	ETF	87.4	87.44	87.3	87.35	69386.0
2009-01-28 19:00:00	SPY	ETF	87.34	87.34	87.26	87.3	37194.0
2009-01-28 19:30:00	SPY	ETF	87.3	87.3	87.16	87.26	106668.0
2009-01-28 04:00:00	QQQ	ETF	29.91	29.91	29.91	29.91	100.0
2009-01-28 04:30:00	QQQ	ETF	29.86	29.94	29.86	29.94	7345.0
2009-01-28 05:00:00	QQQ	ETF	29.94	29.94	29.94	29.94	9153.0
2009-01-28 05:30:00	QQQ	ETF	29.84	29.84	29.82	29.82	200.0
2009-01-28 06:00:00	QQQ	ETF	29.87	29.87	29.87	29.87	100.0
2009-01-28 06:30:00	QQQ	ETF	29.9	29.94	29.89	29.94	7478.0
2009-01-28 07:00:00	QQQ	ETF	29.92	29.92	29.81	29.82	79083.0
2009-01-28 07:30:00	QQQ	ETF	29.81	29.89	29.74	29.89	475050.0
2009-01-28 08:00:00	QQQ	ETF	29.86	29.98	29.5949	29.96	1356957.0
2009-01-28 08:30:00	QQQ	ETF	29.97	29.98	29.84	29.9	287916.0
2009-01-28 09:00:00	QQQ	ETF	29.91	29.91	29.8	29.83	343958.0
2009-01-28 09:30:00	QQQ	ETF	29.82	30.03	29.81	29.87	15585521.0
2009-01-28 10:00:00	QQQ	ETF	29.88	30.01	29.86	30.0	9104058.0
2009-01-28 10:30:00	QQQ	ETF	30.0	30.19	29.98	30.12	10648721.0
2009-01-28 11:00:00	QQQ	ETF	30.12	30.27	30.11	30.21	7918243.0
2009-01-28 11:30:00	QQQ	ETF	30.21	30.26	30.15	30.2	5760226.0
2009-01-28 12:00:00	QQQ	ETF	30.2	30.31	30.19	30.28	4274657.0
2009-01-28 12:30:00	QQQ	ETF	30.28	30.3	30.24	30.25	3522371.0

> showing 50 of 6,810 rows — these rows as CSV

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