PREVIEW / etf_30min / 2009-08-03

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-08-03.parquet
  size:    237 KB
  rows:    7,908

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-03 04:00:00	SPY	ETF	99.22	99.61	99.22	99.61	8092.0
2009-08-03 04:30:00	SPY	ETF	99.61	99.77	99.61	99.77	19300.0
2009-08-03 05:00:00	SPY	ETF	99.72	99.72	99.68	99.68	300.0
2009-08-03 05:30:00	SPY	ETF	99.81	100.08	99.81	100.0	40200.0
2009-08-03 06:00:00	SPY	ETF	100.05	100.09	100.0	100.02	7850.0
2009-08-03 06:30:00	SPY	ETF	100.0	100.07	99.84	99.86	64575.0
2009-08-03 07:00:00	SPY	ETF	99.87	99.91	99.8	99.85	91149.0
2009-08-03 07:30:00	SPY	ETF	99.85	99.89	99.79	99.89	163197.0
2009-08-03 08:00:00	SPY	ETF	99.87	100.19	98.82	99.89	1268831.0
2009-08-03 08:30:00	SPY	ETF	99.89	99.93	99.74	99.82	801507.0
2009-08-03 09:00:00	SPY	ETF	99.82	99.93	99.8	99.85	1140133.0
2009-08-03 09:30:00	SPY	ETF	99.85	100.01	99.31	99.64	27843642.0
2009-08-03 10:00:00	SPY	ETF	99.65	100.15	99.61	100.07	24675797.0
2009-08-03 10:30:00	SPY	ETF	100.08	100.35	99.8	99.86	16339660.0
2009-08-03 11:00:00	SPY	ETF	99.86	99.96	99.67	99.77	10773835.0
2009-08-03 11:30:00	SPY	ETF	99.77	100.07	99.74	100.06	7166353.0
2009-08-03 12:00:00	SPY	ETF	100.06	100.15	99.99	100.02	4343517.0
2009-08-03 12:30:00	SPY	ETF	100.02	100.13	99.78	100.06	5720023.0
2009-08-03 13:00:00	SPY	ETF	100.06	100.28	100.06	100.17	5985046.0
2009-08-03 13:30:00	SPY	ETF	100.17	100.31	100.15	100.23	4366651.0
2009-08-03 14:00:00	SPY	ETF	100.2201	100.53	100.22	100.36	10542113.0
2009-08-03 14:30:00	SPY	ETF	100.37	100.41	100.19	100.2	7736668.0
2009-08-03 15:00:00	SPY	ETF	100.2	100.47	100.18	100.35	7045864.0
2009-08-03 15:30:00	SPY	ETF	100.35	100.41	100.04	100.39	21873754.0
2009-08-03 16:00:00	SPY	ETF	100.4	100.55	98.81	100.47	10682654.0
2009-08-03 16:30:00	SPY	ETF	100.48	100.6	100.2886	100.5	1265177.0
2009-08-03 17:00:00	SPY	ETF	100.17	100.55	100.1	100.52	31260.0
2009-08-03 17:30:00	SPY	ETF	100.5	100.53	99.83	100.5	337917.0
2009-08-03 18:00:00	SPY	ETF	100.32	100.56	100.3	100.53	17832.0
2009-08-03 18:30:00	SPY	ETF	100.53	100.53	100.31	100.49	14418.0
2009-08-03 19:00:00	SPY	ETF	100.45	100.49	100.45	100.48	12561.0
2009-08-03 19:30:00	SPY	ETF	100.49	100.52	100.47	100.49	88899.0
2009-08-03 04:00:00	QQQ	ETF	39.66	39.78	39.66	39.78	652.0
2009-08-03 04:30:00	QQQ	ETF	39.84	39.85	39.83	39.83	12000.0
2009-08-03 05:00:00	QQQ	ETF	39.88	39.88	39.88	39.88	100.0
2009-08-03 05:30:00	QQQ	ETF	39.98	39.98	39.98	39.98	200.0
2009-08-03 06:00:00	QQQ	ETF	39.98	39.98	39.98	39.98	273.0
2009-08-03 06:30:00	QQQ	ETF	40.0	40.0	39.91	39.91	2100.0
2009-08-03 07:00:00	QQQ	ETF	39.96	39.96	39.9	39.91	212937.0
2009-08-03 07:30:00	QQQ	ETF	39.9	39.91	39.86	39.9	116509.0
2009-08-03 08:00:00	QQQ	ETF	39.88	40.04	39.61	39.92	211686.0
2009-08-03 08:30:00	QQQ	ETF	39.9	39.91	39.79	39.83	406825.0
2009-08-03 09:00:00	QQQ	ETF	39.83	39.88	39.83	39.85	446018.0
2009-08-03 09:30:00	QQQ	ETF	39.86	39.97	39.64	39.77	13700927.0
2009-08-03 10:00:00	QQQ	ETF	39.78	39.96	39.74	39.88	16777130.0
2009-08-03 10:30:00	QQQ	ETF	39.89	39.97	39.73	39.75	7999060.0
2009-08-03 11:00:00	QQQ	ETF	39.75	39.8	39.66	39.68	6296161.0
2009-08-03 11:30:00	QQQ	ETF	39.68	39.9	39.67	39.889	10428707.0
2009-08-03 12:00:00	QQQ	ETF	39.89	39.95	39.85	39.862	4586525.0
2009-08-03 12:30:00	QQQ	ETF	39.868	39.94	39.81	39.8942	3336471.0

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

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