PREVIEW / etf_30min / 2009-08-19

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-08-19.parquet
  size:    229 KB
  rows:    7,498

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-08-19 04:00:00	SPY	ETF	98.41	98.45	98.41	98.44	4217.0
2009-08-19 04:30:00	SPY	ETF	98.46	98.46	98.44	98.44	3500.0
2009-08-19 05:00:00	SPY	ETF	98.43	98.43	98.33	98.33	6092.0
2009-08-19 05:30:00	SPY	ETF	98.32	98.44	98.32	98.33	5000.0
2009-08-19 06:00:00	SPY	ETF	98.41	98.41	98.3	98.36	12100.0
2009-08-19 06:30:00	SPY	ETF	98.43	98.44	98.36	98.42	11700.0
2009-08-19 07:00:00	SPY	ETF	98.4	98.69	98.4	98.48	421690.0
2009-08-19 07:30:00	SPY	ETF	98.52	98.63	98.49	98.49	658544.0
2009-08-19 08:00:00	SPY	ETF	98.49	98.51	98.16	98.28	2654986.0
2009-08-19 08:30:00	SPY	ETF	98.27	98.48	98.23	98.38	1474393.0
2009-08-19 09:00:00	SPY	ETF	98.38	98.49	98.26	98.31	2000296.0
2009-08-19 09:30:00	SPY	ETF	98.31	98.96	98.25	98.81	24560276.0
2009-08-19 10:00:00	SPY	ETF	98.81	99.24	98.81	98.96	16036152.0
2009-08-19 10:30:00	SPY	ETF	98.97	99.31	98.94	99.02	17145953.0
2009-08-19 11:00:00	SPY	ETF	99.02	99.21	98.95	99.1199	6683266.0
2009-08-19 11:30:00	SPY	ETF	99.12	99.81	99.01	99.78	13847104.0
2009-08-19 12:00:00	SPY	ETF	99.77	100.18	99.7	100.0	17718214.0
2009-08-19 12:30:00	SPY	ETF	99.99	100.12	99.91	100.055	9077962.0
2009-08-19 13:00:00	SPY	ETF	100.05	100.3	100.04	100.13	8411890.0
2009-08-19 13:30:00	SPY	ETF	100.14	100.21	100.08	100.175	8667976.0
2009-08-19 14:00:00	SPY	ETF	100.1701	100.22	99.97	100.02	8549039.0
2009-08-19 14:30:00	SPY	ETF	100.03	100.065	99.87	100.04	7638885.0
2009-08-19 15:00:00	SPY	ETF	100.0403	100.0499	99.61	99.791	15528141.0
2009-08-19 15:30:00	SPY	ETF	99.8	100.02	99.65	100.0	18049687.0
2009-08-19 16:00:00	SPY	ETF	99.99	100.2	98.47	100.13	8411980.0
2009-08-19 16:30:00	SPY	ETF	100.11	100.13	100.05	100.06	2849631.0
2009-08-19 17:00:00	SPY	ETF	100.07	100.12	99.2817	100.1	1140123.0
2009-08-19 17:30:00	SPY	ETF	100.09	100.24	100.08	100.17	222279.0
2009-08-19 18:00:00	SPY	ETF	100.15	100.15	100.01	100.13	234047.0
2009-08-19 18:30:00	SPY	ETF	100.15	100.15	100.11	100.11	108843.0
2009-08-19 19:00:00	SPY	ETF	100.11	100.15	100.11	100.14	33061.0
2009-08-19 19:30:00	SPY	ETF	100.12	100.13	100.07	100.09	114022.0
2009-08-19 04:00:00	QQQ	ETF	38.64	38.66	38.64	38.66	10740.0
2009-08-19 04:30:00	QQQ	ETF	38.63	38.64	38.63	38.64	5200.0
2009-08-19 05:00:00	QQQ	ETF	38.62	38.62	38.6	38.6	500.0
2009-08-19 05:30:00	QQQ	ETF	38.63	38.63	38.6	38.6	15692.0
2009-08-19 06:00:00	QQQ	ETF	38.61	38.61	38.59	38.59	2600.0
2009-08-19 06:30:00	QQQ	ETF	38.58	38.61	38.57	38.59	132350.0
2009-08-19 07:00:00	QQQ	ETF	38.6	38.69	38.6	38.63	578409.0
2009-08-19 07:30:00	QQQ	ETF	38.65	38.71	38.62	38.62	308643.0
2009-08-19 08:00:00	QQQ	ETF	38.62	38.64	38.53	38.57	1007342.0
2009-08-19 08:30:00	QQQ	ETF	38.57	39.35	38.57	38.61	437959.0
2009-08-19 09:00:00	QQQ	ETF	38.61	38.64	38.58	38.59	1296906.0
2009-08-19 09:30:00	QQQ	ETF	38.59	38.94	38.54	38.8498	13862130.0
2009-08-19 10:00:00	QQQ	ETF	38.85	39.07	38.84	38.92	7203552.0
2009-08-19 10:30:00	QQQ	ETF	38.92	39.01	38.86	38.89	7072097.0
2009-08-19 11:00:00	QQQ	ETF	38.9	38.97	38.85	38.89	2507968.0
2009-08-19 11:30:00	QQQ	ETF	38.9	39.18	38.87	39.17	6772185.0
2009-08-19 12:00:00	QQQ	ETF	39.17	39.35	39.15	39.26	6598212.0
2009-08-19 12:30:00	QQQ	ETF	39.2501	39.33	39.21	39.29	3896688.0

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

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