PREVIEW / etf_30min / 2009-05-12

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-05-12.parquet
  size:    222 KB
  rows:    7,272

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-05-12 04:00:00	SPY	ETF	91.76	91.92	91.76	91.89	2600.0
2009-05-12 04:30:00	SPY	ETF	91.9	91.9	91.69	91.69	2600.0
2009-05-12 05:00:00	SPY	ETF	91.89	91.92	91.89	91.92	300.0
2009-05-12 05:30:00	SPY	ETF	91.71	91.8	91.71	91.8	709.0
2009-05-12 06:00:00	SPY	ETF	91.75	91.75	91.55	91.59	62900.0
2009-05-12 06:30:00	SPY	ETF	91.48	91.5	91.28	91.34	23400.0
2009-05-12 07:00:00	SPY	ETF	91.31	91.57	91.3	91.53	187724.0
2009-05-12 07:30:00	SPY	ETF	91.53	91.71	91.47	91.68	732155.0
2009-05-12 08:00:00	SPY	ETF	91.68	92.0	90.8	91.87	2033690.0
2009-05-12 08:30:00	SPY	ETF	91.86	91.9	91.71	91.77	985846.0
2009-05-12 09:00:00	SPY	ETF	91.76	91.77	91.57	91.64	815999.0
2009-05-12 09:30:00	SPY	ETF	91.63	91.83	90.82	91.05	32444751.0
2009-05-12 10:00:00	SPY	ETF	91.05	91.05	90.48	90.73	19019053.0
2009-05-12 10:30:00	SPY	ETF	90.74	90.83	90.39	90.83	16989001.0
2009-05-12 11:00:00	SPY	ETF	90.83	90.9	90.47	90.57	14913493.0
2009-05-12 11:30:00	SPY	ETF	90.56	90.72	90.33	90.48	15159602.0
2009-05-12 12:00:00	SPY	ETF	90.47	90.58	90.03	90.14	13884158.0
2009-05-12 12:30:00	SPY	ETF	90.15	90.22	89.86	89.8899	12379258.0
2009-05-12 13:00:00	SPY	ETF	89.8891	90.2	89.85	90.1299	11568363.0
2009-05-12 13:30:00	SPY	ETF	90.12	90.37	90.05	90.17	14684820.0
2009-05-12 14:00:00	SPY	ETF	90.17	90.52	90.09	90.35	18933862.0
2009-05-12 14:30:00	SPY	ETF	90.35	91.24	90.27	91.12	36936243.0
2009-05-12 15:00:00	SPY	ETF	91.13	91.69	91.12	91.46	31424976.0
2009-05-12 15:30:00	SPY	ETF	91.46	91.53	90.74	91.02	31035670.0
2009-05-12 16:00:00	SPY	ETF	91.02	91.3	90.05	91.22	6196803.0
2009-05-12 16:30:00	SPY	ETF	91.22	91.35	91.01	91.29	1063273.0
2009-05-12 17:00:00	SPY	ETF	91.29	91.4	91.28	91.4	174308.0
2009-05-12 17:30:00	SPY	ETF	91.38	91.4	91.28	91.36	128938.0
2009-05-12 18:00:00	SPY	ETF	91.36	91.38	91.25	91.27	55509.0
2009-05-12 18:30:00	SPY	ETF	91.26	91.28	91.25	91.25	4405.0
2009-05-12 19:00:00	SPY	ETF	91.3	91.3	91.15	91.18	65450.0
2009-05-12 19:30:00	SPY	ETF	91.14	91.26	91.14	91.23	66000.0
2009-05-12 04:00:00	QQQ	ETF	34.59	34.59	34.55	34.55	2200.0
2009-05-12 06:00:00	QQQ	ETF	34.43	34.43	34.43	34.43	100.0
2009-05-12 06:30:00	QQQ	ETF	34.35	34.35	34.35	34.35	600.0
2009-05-12 07:00:00	QQQ	ETF	34.33	34.46	34.33	34.46	1640.0
2009-05-12 07:30:00	QQQ	ETF	34.47	34.54	34.43	34.51	162199.0
2009-05-12 08:00:00	QQQ	ETF	34.52	34.65	34.37	34.62	2133238.0
2009-05-12 08:30:00	QQQ	ETF	34.62	34.62	34.53	34.55	433793.0
2009-05-12 09:00:00	QQQ	ETF	34.55	34.55	34.42	34.43	586616.0
2009-05-12 09:30:00	QQQ	ETF	34.43	34.48	33.92	34.0201	22299881.0
2009-05-12 10:00:00	QQQ	ETF	34.03	34.08	33.87	34.01	11024813.0
2009-05-12 10:30:00	QQQ	ETF	34.01	34.015	33.8	33.94	7401563.0
2009-05-12 11:00:00	QQQ	ETF	33.94	33.965	33.76	33.79	7159123.0
2009-05-12 11:30:00	QQQ	ETF	33.79	33.84	33.69	33.74	6168588.0
2009-05-12 12:00:00	QQQ	ETF	33.73	33.76	33.52	33.6	10319539.0
2009-05-12 12:30:00	QQQ	ETF	33.6	33.63	33.52	33.53	5878663.0
2009-05-12 13:00:00	QQQ	ETF	33.52	33.66	33.52	33.64	9843683.0
2009-05-12 13:30:00	QQQ	ETF	33.65	33.76	33.61	33.67	6920426.0
2009-05-12 14:00:00	QQQ	ETF	33.68	33.78	33.64	33.6701	5680300.0

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

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