PREVIEW / etf_30min / 2009-04-03

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-04-03.parquet
  size:    214 KB
  rows:    7,061

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-04-03 04:00:00	SPY	ETF	83.48	83.7	83.48	83.7	2500.0
2009-04-03 04:30:00	SPY	ETF	83.72	83.96	83.72	83.96	6150.0
2009-04-03 05:00:00	SPY	ETF	84.0	84.2	84.0	84.14	6900.0
2009-04-03 05:30:00	SPY	ETF	84.12	84.2	83.99	84.08	2600.0
2009-04-03 06:00:00	SPY	ETF	84.23	84.23	83.9	84.06	15350.0
2009-04-03 06:30:00	SPY	ETF	84.19	84.3	84.14	84.2	7000.0
2009-04-03 07:00:00	SPY	ETF	84.2	84.2	83.95	84.09	139395.0
2009-04-03 07:30:00	SPY	ETF	84.1	84.27	84.1	84.21	288336.0
2009-04-03 08:00:00	SPY	ETF	84.21	84.55	83.53	84.54	1405069.0
2009-04-03 08:30:00	SPY	ETF	84.55	84.83	83.48	83.61	8978813.0
2009-04-03 09:00:00	SPY	ETF	83.61	84.4	83.33	83.48	2460986.0
2009-04-03 09:30:00	SPY	ETF	83.49	83.71	83.1	83.37	33887798.0
2009-04-03 10:00:00	SPY	ETF	83.35	83.4125	82.84	83.1	24697136.0
2009-04-03 10:30:00	SPY	ETF	83.09	83.18	82.67	82.9499	16012838.0
2009-04-03 11:00:00	SPY	ETF	82.94	83.1	82.73	82.9701	13914479.0
2009-04-03 11:30:00	SPY	ETF	82.98	83.38	82.95	83.35	13990333.0
2009-04-03 12:00:00	SPY	ETF	83.35	83.69	83.3	83.6599	16580034.0
2009-04-03 12:30:00	SPY	ETF	83.66	83.76	83.34	83.43	14470007.0
2009-04-03 13:00:00	SPY	ETF	83.43	83.6	83.26	83.56	11837847.0
2009-04-03 13:30:00	SPY	ETF	83.56	83.77	83.26	83.75	16004036.0
2009-04-03 14:00:00	SPY	ETF	83.75	84.18	83.58	84.14	18076087.0
2009-04-03 14:30:00	SPY	ETF	84.13	84.2	83.77	84.0	17131865.0
2009-04-03 15:00:00	SPY	ETF	83.99	84.03	83.45	83.52	21736154.0
2009-04-03 15:30:00	SPY	ETF	83.53	84.28	82.9	84.25	39235820.0
2009-04-03 16:00:00	SPY	ETF	84.25	84.62	83.4746	84.51	9776351.0
2009-04-03 16:30:00	SPY	ETF	84.51	84.57	83.5	84.55	353697.0
2009-04-03 17:00:00	SPY	ETF	84.54	84.54	84.43	84.48	141424.0
2009-04-03 17:30:00	SPY	ETF	84.49	84.53	84.43	84.47	27699.0
2009-04-03 18:00:00	SPY	ETF	84.47	84.5	84.42	84.45	59011.0
2009-04-03 18:30:00	SPY	ETF	84.45	84.45	84.43	84.43	8453.0
2009-04-03 19:00:00	SPY	ETF	84.45	84.49	84.41	84.44	17924.0
2009-04-03 19:30:00	SPY	ETF	84.41	84.49	84.35	84.4	47450.0
2009-04-03 04:30:00	QQQ	ETF	32.01	32.07	32.01	32.07	200.0
2009-04-03 05:00:00	QQQ	ETF	32.1	32.18	32.1	32.18	2300.0
2009-04-03 05:30:00	QQQ	ETF	32.13	32.19	32.13	32.19	2500.0
2009-04-03 06:00:00	QQQ	ETF	32.25	32.25	32.15	32.18	2300.0
2009-04-03 06:30:00	QQQ	ETF	32.22	32.25	32.22	32.25	45769.0
2009-04-03 07:00:00	QQQ	ETF	32.22	32.23	32.12	32.16	43924.0
2009-04-03 07:30:00	QQQ	ETF	32.26	32.29	32.18	32.22	93587.0
2009-04-03 08:00:00	QQQ	ETF	32.21	32.34	31.85	32.3	574874.0
2009-04-03 08:30:00	QQQ	ETF	32.3	32.36	32.01	32.07	2395419.0
2009-04-03 09:00:00	QQQ	ETF	32.08	32.1	31.97	32.06	1329183.0
2009-04-03 09:30:00	QQQ	ETF	32.05	32.22	31.91	32.01	18210857.0
2009-04-03 10:00:00	QQQ	ETF	32.02	32.04	31.83	32.01	11925068.0
2009-04-03 10:30:00	QQQ	ETF	32.01	32.04	31.85	31.959	7596362.0
2009-04-03 11:00:00	QQQ	ETF	31.96	32.04	31.89	31.98	5704251.0
2009-04-03 11:30:00	QQQ	ETF	31.98	32.13	31.97	32.12	6220274.0
2009-04-03 12:00:00	QQQ	ETF	32.12	32.23	32.09	32.2201	5952068.0
2009-04-03 12:30:00	QQQ	ETF	32.228	32.27	32.08	32.1301	7299335.0
2009-04-03 13:00:00	QQQ	ETF	32.14	32.2396	32.105	32.221	5315308.0

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

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