PREVIEW / etf_30min / 2009-08-18

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-08-18.parquet
  size:    228 KB
  rows:    7,455

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-18 04:00:00	SPY	ETF	98.7	98.8	98.7	98.8	5800.0
2009-08-18 04:30:00	SPY	ETF	98.75	98.97	98.75	98.95	14320.0
2009-08-18 05:00:00	SPY	ETF	98.93	99.02	98.9	98.9	5625.0
2009-08-18 05:30:00	SPY	ETF	98.87	98.9	98.78	98.8	62400.0
2009-08-18 06:00:00	SPY	ETF	98.85	99.0	98.85	99.0	118200.0
2009-08-18 06:30:00	SPY	ETF	98.92	98.94	98.84	98.94	6300.0
2009-08-18 07:00:00	SPY	ETF	98.9	98.92	98.79	98.84	190125.0
2009-08-18 07:30:00	SPY	ETF	98.81	98.86	98.72	98.84	404946.0
2009-08-18 08:00:00	SPY	ETF	98.83	98.97	98.6	98.97	1058034.0
2009-08-18 08:30:00	SPY	ETF	98.97	98.97	98.48	98.52	2719661.0
2009-08-18 09:00:00	SPY	ETF	98.52	98.93	98.49	98.55	1847979.0
2009-08-18 09:30:00	SPY	ETF	98.53	98.78	98.35	98.535	23664629.0
2009-08-18 10:00:00	SPY	ETF	98.52	98.97	98.51	98.7	17791842.0
2009-08-18 10:30:00	SPY	ETF	98.69	98.82	98.625	98.6896	14508825.0
2009-08-18 11:00:00	SPY	ETF	98.68	98.95	98.68	98.91	11695283.0
2009-08-18 11:30:00	SPY	ETF	98.91	99.2	98.91	99.13	13864487.0
2009-08-18 12:00:00	SPY	ETF	99.12	99.37	99.11	99.19	11201008.0
2009-08-18 12:30:00	SPY	ETF	99.18	99.33	98.65	99.22	6886777.0
2009-08-18 13:00:00	SPY	ETF	99.22	99.35	99.11	99.21	9454478.0
2009-08-18 13:30:00	SPY	ETF	99.2	99.26	99.01	99.16	7159247.0
2009-08-18 14:00:00	SPY	ETF	99.16	99.35	99.15	99.35	5785875.0
2009-08-18 14:30:00	SPY	ETF	99.35	99.41	99.16	99.22	6526358.0
2009-08-18 15:00:00	SPY	ETF	99.22	99.44	99.21	99.26	8457175.0
2009-08-18 15:30:00	SPY	ETF	99.26	99.42	99.11	99.19	19518269.0
2009-08-18 16:00:00	SPY	ETF	99.18	99.47	98.55	99.37	9011144.0
2009-08-18 16:30:00	SPY	ETF	99.38	99.43	99.1791	99.34	435600.0
2009-08-18 17:00:00	SPY	ETF	99.34	99.39	99.24	99.24	195535.0
2009-08-18 17:30:00	SPY	ETF	99.28	99.28	99.23	99.27	13068.0
2009-08-18 18:00:00	SPY	ETF	99.26	99.31	99.16	99.27	40519.0
2009-08-18 18:30:00	SPY	ETF	99.25	99.3	99.25	99.27	11500.0
2009-08-18 19:00:00	SPY	ETF	99.27	99.28	99.27	99.27	4100.0
2009-08-18 19:30:00	SPY	ETF	99.27	99.33	99.25	99.33	10484.0
2009-08-18 04:30:00	QQQ	ETF	38.78	38.85	38.78	38.85	1802.0
2009-08-18 05:00:00	QQQ	ETF	38.86	38.88	38.82	38.83	7185.0
2009-08-18 06:00:00	QQQ	ETF	38.85	38.89	38.85	38.89	7100.0
2009-08-18 06:30:00	QQQ	ETF	38.85	38.88	38.85	38.88	900.0
2009-08-18 07:00:00	QQQ	ETF	38.84	38.87	38.81	38.82	52100.0
2009-08-18 07:30:00	QQQ	ETF	38.82	38.87	38.79	38.85	141350.0
2009-08-18 08:00:00	QQQ	ETF	38.85	38.88	38.7	38.88	750392.0
2009-08-18 08:30:00	QQQ	ETF	38.86	38.86	38.7	38.71	689950.0
2009-08-18 09:00:00	QQQ	ETF	38.71	38.77	38.71	38.73	248240.0
2009-08-18 09:30:00	QQQ	ETF	38.72	38.85	38.61	38.68	12573725.0
2009-08-18 10:00:00	QQQ	ETF	38.68	38.85	38.68	38.71	8649557.0
2009-08-18 10:30:00	QQQ	ETF	38.7	38.8	38.68	38.74	4505338.0
2009-08-18 11:00:00	QQQ	ETF	38.74	38.9	38.74	38.88	5686895.0
2009-08-18 11:30:00	QQQ	ETF	38.89	38.98	38.88	38.93	4627127.0
2009-08-18 12:00:00	QQQ	ETF	38.94	38.98	38.92	38.9474	2805658.0
2009-08-18 12:30:00	QQQ	ETF	38.95	39.98	38.93	39.0	3036302.0
2009-08-18 13:00:00	QQQ	ETF	39.0	39.05	38.95	38.99	3506298.0
2009-08-18 13:30:00	QQQ	ETF	38.99	39.02	38.91	38.96	3186944.0

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

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