PREVIEW / etf_30min / 2010-04-15

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-04-15.parquet
  size:    252 KB
  rows:    8,505

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
2010-04-15 04:00:00	SPY	ETF	120.94	120.94	120.93	120.93	1500.0
2010-04-15 04:30:00	SPY	ETF	120.93	120.93	120.87	120.87	4140.0
2010-04-15 05:00:00	SPY	ETF	120.76	120.76	120.68	120.68	1800.0
2010-04-15 05:30:00	SPY	ETF	120.68	120.73	120.65	120.73	49740.0
2010-04-15 06:00:00	SPY	ETF	120.81	120.86	120.81	120.83	3200.0
2010-04-15 06:30:00	SPY	ETF	120.91	121.0	120.88	120.9	14300.0
2010-04-15 07:00:00	SPY	ETF	120.89	120.92	120.83	120.88	124913.0
2010-04-15 07:30:00	SPY	ETF	120.86	120.91	120.83	120.91	234388.0
2010-04-15 08:00:00	SPY	ETF	120.9	121.15	120.87	120.99	331955.0
2010-04-15 08:30:00	SPY	ETF	120.99	121.01	120.74	120.91	1829867.0
2010-04-15 09:00:00	SPY	ETF	120.92	121.01	120.85	121.01	1550370.0
2010-04-15 09:30:00	SPY	ETF	120.99	121.12	120.95	121.05	13327836.0
2010-04-15 10:00:00	SPY	ETF	121.05	121.29	120.96	121.211	11903208.0
2010-04-15 10:30:00	SPY	ETF	121.21	121.482	121.2	121.47	12661591.0
2010-04-15 11:00:00	SPY	ETF	121.47	121.5654	121.18	121.21	13460341.0
2010-04-15 11:30:00	SPY	ETF	121.2075	121.29	121.01	121.09	11240453.0
2010-04-15 12:00:00	SPY	ETF	121.09	121.22	120.95	121.08	10729721.0
2010-04-15 12:30:00	SPY	ETF	121.08	121.21	121.0301	121.2	4781799.0
2010-04-15 13:00:00	SPY	ETF	121.2	121.43	121.15	121.42	8605858.0
2010-04-15 13:30:00	SPY	ETF	121.42	121.45	121.29	121.36	5228582.0
2010-04-15 14:00:00	SPY	ETF	121.36	121.46	121.33	121.42	5813911.0
2010-04-15 14:30:00	SPY	ETF	121.41	121.51	121.33	121.49	6242248.0
2010-04-15 15:00:00	SPY	ETF	121.49	121.49	121.2	121.22	8875323.0
2010-04-15 15:30:00	SPY	ETF	121.22	121.34	121.1	121.31	18293145.0
2010-04-15 16:00:00	SPY	ETF	121.3	121.35	120.8961	121.24	7348687.0
2010-04-15 16:30:00	SPY	ETF	121.26	121.32	121.1	121.11	761383.0
2010-04-15 17:00:00	SPY	ETF	121.11	121.15	121.07	121.11	115853.0
2010-04-15 17:30:00	SPY	ETF	121.1	121.1	121.03	121.05	75221.0
2010-04-15 18:00:00	SPY	ETF	121.06	121.13	121.05	121.09	62597.0
2010-04-15 18:30:00	SPY	ETF	121.1	121.14	121.08	121.12	18495.0
2010-04-15 19:00:00	SPY	ETF	121.11	121.12	121.11	121.11	4000.0
2010-04-15 19:30:00	SPY	ETF	121.09	121.12	121.0	121.01	27137.0
2010-04-15 04:30:00	QQQ	ETF	49.81	49.81	49.81	49.81	200.0
2010-04-15 05:00:00	QQQ	ETF	49.73	49.73	49.73	49.73	250.0
2010-04-15 06:30:00	QQQ	ETF	49.79	49.79	49.79	49.79	12000.0
2010-04-15 07:00:00	QQQ	ETF	49.8	49.82	49.78	49.79	45133.0
2010-04-15 07:30:00	QQQ	ETF	49.79	49.79	49.77	49.78	44462.0
2010-04-15 08:00:00	QQQ	ETF	49.79	49.85	49.75	49.85	106741.0
2010-04-15 08:30:00	QQQ	ETF	49.86	49.86	49.73	49.84	832277.0
2010-04-15 09:00:00	QQQ	ETF	49.85	49.89	49.81	49.88	546159.0
2010-04-15 09:30:00	QQQ	ETF	49.88	50.0	49.87	49.96	9483247.0
2010-04-15 10:00:00	QQQ	ETF	49.96	50.05	49.9	50.03	5573248.0
2010-04-15 10:30:00	QQQ	ETF	50.03	50.15	50.03	50.13	6456365.0
2010-04-15 11:00:00	QQQ	ETF	50.13	50.19	50.07	50.075	5013187.0
2010-04-15 11:30:00	QQQ	ETF	50.08	50.12	49.98	50.02	4450831.0
2010-04-15 12:00:00	QQQ	ETF	50.02	50.09	49.98	50.04	4430670.0
2010-04-15 12:30:00	QQQ	ETF	50.03	50.07	50.01	50.07	1935512.0
2010-04-15 13:00:00	QQQ	ETF	50.07	50.14	50.04	50.14	2930338.0
2010-04-15 13:30:00	QQQ	ETF	50.14	50.15	50.09	50.1062	2617801.0
2010-04-15 14:00:00	QQQ	ETF	50.1062	50.16	50.06	50.16	2448499.0

> showing 50 of 8,505 rows — these rows as CSV

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