PREVIEW / etf_30min / 2009-07-29

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-07-29.parquet
  size:    223 KB
  rows:    7,327

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-07-29 04:00:00	SPY	ETF	97.58	97.86	97.58	97.66	2700.0
2009-07-29 05:00:00	SPY	ETF	97.66	97.76	97.66	97.76	4100.0
2009-07-29 05:30:00	SPY	ETF	97.66	97.66	97.4	97.4	107300.0
2009-07-29 06:00:00	SPY	ETF	97.47	97.7	97.47	97.7	36850.0
2009-07-29 06:30:00	SPY	ETF	97.76	97.81	97.67	97.67	62100.0
2009-07-29 07:00:00	SPY	ETF	97.75	97.75	97.57	97.57	136196.0
2009-07-29 07:30:00	SPY	ETF	97.58	97.63	97.43	97.43	608990.0
2009-07-29 08:00:00	SPY	ETF	97.43	97.77	97.14	97.72	2438516.0
2009-07-29 08:30:00	SPY	ETF	97.72	97.84	97.28	97.37	3768003.0
2009-07-29 09:00:00	SPY	ETF	97.36	97.48	97.15	97.45	2082279.0
2009-07-29 09:30:00	SPY	ETF	97.44	97.62	97.1	97.57	21015471.0
2009-07-29 10:00:00	SPY	ETF	97.57	97.93	97.51	97.71	19743855.0
2009-07-29 10:30:00	SPY	ETF	97.71	97.72	97.35	97.55	14541516.0
2009-07-29 11:00:00	SPY	ETF	97.55	97.7	97.2	97.28	11222715.0
2009-07-29 11:30:00	SPY	ETF	97.27	97.45	97.08	97.43	9504664.0
2009-07-29 12:00:00	SPY	ETF	97.43	97.53	97.37	97.48	7267739.0
2009-07-29 12:30:00	SPY	ETF	97.48	97.68	97.46	97.56	6429360.0
2009-07-29 13:00:00	SPY	ETF	97.55	97.55	97.02	97.09	17058384.0
2009-07-29 13:30:00	SPY	ETF	97.1	97.65	96.98	97.23	10394072.0
2009-07-29 14:00:00	SPY	ETF	97.24	97.47	97.05	97.43	10807138.0
2009-07-29 14:30:00	SPY	ETF	97.43	97.44	97.01	97.04	8051848.0
2009-07-29 15:00:00	SPY	ETF	97.04	97.39	97.03	97.34	10453329.0
2009-07-29 15:30:00	SPY	ETF	97.3399	97.8	97.31	97.6583	24317666.0
2009-07-29 16:00:00	SPY	ETF	97.65	97.94	97.265	97.87	8080681.0
2009-07-29 16:30:00	SPY	ETF	97.85	97.91	97.81	97.91	233625.0
2009-07-29 17:00:00	SPY	ETF	97.9	98.05	97.24	98.02	461721.0
2009-07-29 17:30:00	SPY	ETF	98.03	98.05	98.0	98.01	39751.0
2009-07-29 18:00:00	SPY	ETF	98.0	98.0	97.91	97.93	78841.0
2009-07-29 18:30:00	SPY	ETF	97.92	97.94	97.88	97.9	21936.0
2009-07-29 19:00:00	SPY	ETF	97.88	97.9	97.87	97.9	24155.0
2009-07-29 19:30:00	SPY	ETF	97.9	97.95	97.81	97.93	47015.0
2009-07-29 04:30:00	QQQ	ETF	39.35	39.35	39.35	39.35	200.0
2009-07-29 05:00:00	QQQ	ETF	39.38	39.38	39.38	39.38	3000.0
2009-07-29 06:30:00	QQQ	ETF	39.35	39.44	39.35	39.43	8800.0
2009-07-29 07:00:00	QQQ	ETF	39.41	39.43	39.32	39.33	73404.0
2009-07-29 07:30:00	QQQ	ETF	39.31	39.31	39.24	39.25	730612.0
2009-07-29 08:00:00	QQQ	ETF	39.25	39.35	39.11	39.35	577623.0
2009-07-29 08:30:00	QQQ	ETF	39.34	39.38	39.19	39.22	765559.0
2009-07-29 09:00:00	QQQ	ETF	39.22	39.33	39.15	39.31	677444.0
2009-07-29 09:30:00	QQQ	ETF	39.31	39.37	39.0906	39.26	14221905.0
2009-07-29 10:00:00	QQQ	ETF	39.27	39.43	39.15	39.37	10734356.0
2009-07-29 10:30:00	QQQ	ETF	39.36	39.4	39.22	39.32	13712896.0
2009-07-29 11:00:00	QQQ	ETF	39.32	39.36	39.16	39.1799	7160026.0
2009-07-29 11:30:00	QQQ	ETF	39.178	39.26	39.11	39.2504	9377286.0
2009-07-29 12:00:00	QQQ	ETF	39.25	39.3	39.2299	39.2976	4778667.0
2009-07-29 12:30:00	QQQ	ETF	39.29	39.37	39.27	39.29	4758101.0
2009-07-29 13:00:00	QQQ	ETF	39.29	39.29	39.08	39.11	7825686.0
2009-07-29 13:30:00	QQQ	ETF	39.11	39.22	39.0	39.2021	13992047.0
2009-07-29 14:00:00	QQQ	ETF	39.21	39.31	39.14	39.2999	5199147.0
2009-07-29 14:30:00	QQQ	ETF	39.291	39.291	39.13	39.14	2483297.0

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

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