PREVIEW / etf_30min / 2009-09-01

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-09-01.parquet
  size:    238 KB
  rows:    7,787

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-09-01 04:00:00	SPY	ETF	102.47	102.47	101.89	101.89	5200.0
2009-09-01 04:30:00	SPY	ETF	101.76	101.9	101.67	101.9	6200.0
2009-09-01 05:00:00	SPY	ETF	101.82	101.85	101.75	101.75	20300.0
2009-09-01 05:30:00	SPY	ETF	101.6	101.81	101.6	101.81	1315.0
2009-09-01 06:00:00	SPY	ETF	101.75	101.76	101.7	101.75	900.0
2009-09-01 06:30:00	SPY	ETF	101.69	101.7	101.65	101.7	2050.0
2009-09-01 07:00:00	SPY	ETF	101.69	101.85	101.63	101.83	252118.0
2009-09-01 07:30:00	SPY	ETF	101.83	101.96	101.83	101.96	504569.0
2009-09-01 08:00:00	SPY	ETF	101.96	102.46	101.93	102.02	2272253.0
2009-09-01 08:30:00	SPY	ETF	102.02	102.05	101.85	101.96	1638952.0
2009-09-01 09:00:00	SPY	ETF	101.97	102.03	101.83	101.98	1182507.0
2009-09-01 09:30:00	SPY	ETF	101.95	102.97	101.89	102.83	28138416.0
2009-09-01 10:00:00	SPY	ETF	102.83	103.24	102.52	102.78	36087049.0
2009-09-01 10:30:00	SPY	ETF	102.78	102.89	102.22	102.22	15020075.0
2009-09-01 11:00:00	SPY	ETF	102.22	102.24	100.96	101.01	37390529.0
2009-09-01 11:30:00	SPY	ETF	101.01	101.02	100.49	100.7	32538840.0
2009-09-01 12:00:00	SPY	ETF	100.7	100.92	100.39	100.49	18950507.0
2009-09-01 12:30:00	SPY	ETF	100.49	100.73	100.4	100.56	10958274.0
2009-09-01 13:00:00	SPY	ETF	100.56	100.67	100.23	100.47	16020791.0
2009-09-01 13:30:00	SPY	ETF	100.47	100.7	100.29	100.67	14861281.0
2009-09-01 14:00:00	SPY	ETF	100.6799	100.75	100.38	100.53	11767645.0
2009-09-01 14:30:00	SPY	ETF	100.5394	100.67	100.33	100.48	16518990.0
2009-09-01 15:00:00	SPY	ETF	100.48	100.67	100.19	100.2306	16583773.0
2009-09-01 15:30:00	SPY	ETF	100.23	100.54	99.99	100.16	40418424.0
2009-09-01 16:00:00	SPY	ETF	100.17	102.99	100.0	100.11	11547208.0
2009-09-01 16:30:00	SPY	ETF	100.11	100.17	100.05	100.13	5331082.0
2009-09-01 17:00:00	SPY	ETF	100.13	102.4436	100.08	100.15	2123229.0
2009-09-01 17:30:00	SPY	ETF	100.11	100.14	100.04	100.09	46250.0
2009-09-01 18:00:00	SPY	ETF	100.1	100.2	100.1	100.14	87965.0
2009-09-01 18:30:00	SPY	ETF	100.16	100.18	100.13	100.17	11452.0
2009-09-01 19:00:00	SPY	ETF	100.16	100.17	100.1	100.13	12450.0
2009-09-01 19:30:00	SPY	ETF	100.13	100.19	100.05	100.06	25187.0
2009-09-01 04:00:00	QQQ	ETF	40.06	40.06	39.87	39.87	3158.0
2009-09-01 04:30:00	QQQ	ETF	39.74	39.82	39.74	39.82	200.0
2009-09-01 05:00:00	QQQ	ETF	39.78	39.78	39.72	39.72	200.0
2009-09-01 05:30:00	QQQ	ETF	39.7	39.7	39.7	39.7	300.0
2009-09-01 06:00:00	QQQ	ETF	39.73	39.74	39.73	39.73	560.0
2009-09-01 06:30:00	QQQ	ETF	39.72	39.74	39.71	39.71	3765.0
2009-09-01 07:00:00	QQQ	ETF	39.72	39.8	39.69	39.8	116700.0
2009-09-01 07:30:00	QQQ	ETF	39.8	39.88	39.8	39.84	328902.0
2009-09-01 08:00:00	QQQ	ETF	39.85	40.03	39.83	39.9	1704803.0
2009-09-01 08:30:00	QQQ	ETF	39.9	39.93	39.86	39.88	666652.0
2009-09-01 09:00:00	QQQ	ETF	39.89	39.92	39.85	39.88	535043.0
2009-09-01 09:30:00	QQQ	ETF	39.87	40.47	39.86	40.37	15052590.0
2009-09-01 10:00:00	QQQ	ETF	40.38	40.59	40.28	40.4	20627323.0
2009-09-01 10:30:00	QQQ	ETF	40.3901	40.4601	40.15	40.15	8226128.0
2009-09-01 11:00:00	QQQ	ETF	40.15	40.215	39.54	39.56	20846726.0
2009-09-01 11:30:00	QQQ	ETF	39.56	39.85	39.4	39.4	16196264.0
2009-09-01 12:00:00	QQQ	ETF	39.41	39.49	39.35	39.4	9067856.0
2009-09-01 12:30:00	QQQ	ETF	39.4	39.48	39.33	39.35	4556630.0

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

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