PREVIEW / etf_30min / 2009-04-20

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-04-20.parquet
  size:    221 KB
  rows:    7,286

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-20 04:00:00	SPY	ETF	86.42	86.46	86.38	86.38	7862.0
2009-04-20 04:30:00	SPY	ETF	86.33	86.4	86.22	86.29	8090.0
2009-04-20 05:00:00	SPY	ETF	86.28	86.28	85.97	86.01	14121.0
2009-04-20 05:30:00	SPY	ETF	85.97	86.03	85.88	85.92	41500.0
2009-04-20 06:00:00	SPY	ETF	85.86	86.16	85.86	86.09	39937.0
2009-04-20 06:30:00	SPY	ETF	86.17	86.17	85.95	86.09	127907.0
2009-04-20 07:00:00	SPY	ETF	86.17	86.25	85.81	85.89	782631.0
2009-04-20 07:30:00	SPY	ETF	85.92	86.17	85.71	85.75	719426.0
2009-04-20 08:00:00	SPY	ETF	85.75	85.9	85.36	85.43	2291652.0
2009-04-20 08:30:00	SPY	ETF	85.44	86.09	85.44	85.54	1842561.0
2009-04-20 09:00:00	SPY	ETF	85.54	85.78	85.42	85.55	2116330.0
2009-04-20 09:30:00	SPY	ETF	85.54	85.66	84.85	84.97	28303799.0
2009-04-20 10:00:00	SPY	ETF	84.9601	85.03	84.53	84.61	21342863.0
2009-04-20 10:30:00	SPY	ETF	84.6	84.65	84.18	84.29	19513415.0
2009-04-20 11:00:00	SPY	ETF	84.29	84.44	84.08	84.38	15813861.0
2009-04-20 11:30:00	SPY	ETF	84.38	84.43	84.12	84.17	15025912.0
2009-04-20 12:00:00	SPY	ETF	84.17	85.25	84.0	84.1	15274254.0
2009-04-20 12:30:00	SPY	ETF	84.09	84.3	83.97	84.21	11703670.0
2009-04-20 13:00:00	SPY	ETF	84.21	84.22	83.73	83.74	12177257.0
2009-04-20 13:30:00	SPY	ETF	83.74	85.1	83.71	83.97	9966427.0
2009-04-20 14:00:00	SPY	ETF	83.96	84.15	83.67	83.84	10806182.0
2009-04-20 14:30:00	SPY	ETF	83.84	84.25	83.51	83.5501	17208211.0
2009-04-20 15:00:00	SPY	ETF	83.56	87.0489	83.41	83.52	17100805.0
2009-04-20 15:30:00	SPY	ETF	83.53	83.91	83.34	83.41	53073753.0
2009-04-20 16:00:00	SPY	ETF	83.43	84.8	83.4	83.59	20162515.0
2009-04-20 16:30:00	SPY	ETF	83.59	87.0489	83.58	83.79	2783187.0
2009-04-20 17:00:00	SPY	ETF	83.8	87.0489	83.75	83.81	4842548.0
2009-04-20 17:30:00	SPY	ETF	83.84	83.84	83.72	83.74	163110.0
2009-04-20 18:00:00	SPY	ETF	83.78	83.79	83.71	83.71	59274.0
2009-04-20 18:30:00	SPY	ETF	83.74	83.76	83.72	83.74	9940.0
2009-04-20 19:00:00	SPY	ETF	83.74	83.78	83.72	83.75	28672.0
2009-04-20 19:30:00	SPY	ETF	83.73	83.81	83.73	83.76	38129.0
2009-04-20 04:00:00	QQQ	ETF	33.04	33.04	33.03	33.03	989.0
2009-04-20 05:00:00	QQQ	ETF	32.89	32.89	32.87	32.88	594.0
2009-04-20 05:30:00	QQQ	ETF	32.87	32.87	32.83	32.83	4890.0
2009-04-20 06:00:00	QQQ	ETF	32.8	32.8	32.77	32.78	25100.0
2009-04-20 06:30:00	QQQ	ETF	32.79	32.8	32.74	32.74	26100.0
2009-04-20 07:00:00	QQQ	ETF	32.78	32.84	32.68	32.74	91261.0
2009-04-20 07:30:00	QQQ	ETF	32.75	32.84	32.67	32.67	427407.0
2009-04-20 08:00:00	QQQ	ETF	32.68	32.74	32.61	32.65	849344.0
2009-04-20 08:30:00	QQQ	ETF	32.66	32.75	32.64	32.66	633777.0
2009-04-20 09:00:00	QQQ	ETF	32.66	32.73	32.63	32.69	885231.0
2009-04-20 09:30:00	QQQ	ETF	32.69	32.82	32.55	32.58	17333816.0
2009-04-20 10:00:00	QQQ	ETF	32.58	32.59	32.31	32.36	12332060.0
2009-04-20 10:30:00	QQQ	ETF	32.37	32.38	32.18	32.25	8714449.0
2009-04-20 11:00:00	QQQ	ETF	32.24	32.37	32.17	32.3395	7526550.0
2009-04-20 11:30:00	QQQ	ETF	32.33	32.35	32.2	32.22	6569365.0
2009-04-20 12:00:00	QQQ	ETF	32.21	32.25	32.15	32.21	6005430.0
2009-04-20 12:30:00	QQQ	ETF	32.22	32.35	32.17	32.3399	4817746.0
2009-04-20 13:00:00	QQQ	ETF	32.33	32.33	32.19	32.25	3515256.0

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

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