PREVIEW / etf_30min / 2009-10-20

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-10-20.parquet
  size:    237 KB
  rows:    7,730

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-10-20 04:00:00	SPY	ETF	109.54	109.59	109.44	109.59	7100.0
2009-10-20 04:30:00	SPY	ETF	109.61	109.61	109.61	109.61	500.0
2009-10-20 05:00:00	SPY	ETF	109.79	109.79	109.75	109.75	200.0
2009-10-20 05:30:00	SPY	ETF	109.71	109.81	109.71	109.81	700.0
2009-10-20 06:00:00	SPY	ETF	109.86	109.86	109.72	109.72	4900.0
2009-10-20 06:30:00	SPY	ETF	109.74	109.77	109.68	109.68	9200.0
2009-10-20 07:00:00	SPY	ETF	109.71	109.99	109.71	109.97	108407.0
2009-10-20 07:30:00	SPY	ETF	109.97	110.36	109.96	110.17	761662.0
2009-10-20 08:00:00	SPY	ETF	110.14	110.19	109.45	109.97	1940802.0
2009-10-20 08:30:00	SPY	ETF	109.95	109.97	109.59	109.89	3049687.0
2009-10-20 09:00:00	SPY	ETF	109.88	110.05	109.86	109.95	1945226.0
2009-10-20 09:30:00	SPY	ETF	109.95	109.985	109.32	109.64	24879152.0
2009-10-20 10:00:00	SPY	ETF	109.64	109.77	109.21	109.41	18261392.0
2009-10-20 10:30:00	SPY	ETF	109.4	109.66	109.32	109.6	10554445.0
2009-10-20 11:00:00	SPY	ETF	109.59	109.63	109.28	109.34	8109336.0
2009-10-20 11:30:00	SPY	ETF	109.35	109.39	108.82	109.0008	13488448.0
2009-10-20 12:00:00	SPY	ETF	109.0099	109.06	108.73	108.93	12458465.0
2009-10-20 12:30:00	SPY	ETF	108.93	109.1	108.68	108.91	8604103.0
2009-10-20 13:00:00	SPY	ETF	108.91	109.1	108.9	109.04	5828812.0
2009-10-20 13:30:00	SPY	ETF	109.04	109.12	108.83	108.89	8128368.0
2009-10-20 14:00:00	SPY	ETF	108.88	109.23	108.83	109.05	11756727.0
2009-10-20 14:30:00	SPY	ETF	109.06	109.8888	108.98	109.179	9338798.0
2009-10-20 15:00:00	SPY	ETF	109.18	109.5154	108.91	109.09	10107073.0
2009-10-20 15:30:00	SPY	ETF	109.08	109.32	109.08	109.22	20774276.0
2009-10-20 16:00:00	SPY	ETF	109.22	109.8888	108.95	109.37	6799903.0
2009-10-20 16:30:00	SPY	ETF	109.37	109.38	109.22	109.27	1829142.0
2009-10-20 17:00:00	SPY	ETF	109.27	109.8888	109.13	109.21	1602142.0
2009-10-20 17:30:00	SPY	ETF	109.22	109.23	109.17	109.22	20981.0
2009-10-20 18:00:00	SPY	ETF	109.25	109.35	109.24	109.34	16690.0
2009-10-20 18:30:00	SPY	ETF	109.35	109.35	109.25	109.25	4072.0
2009-10-20 19:00:00	SPY	ETF	109.25	109.3	109.22	109.3	6700.0
2009-10-20 19:30:00	SPY	ETF	109.27	109.35	109.22	109.3	70273.0
2009-10-20 04:00:00	QQQ	ETF	43.36	43.36	43.36	43.36	100.0
2009-10-20 04:30:00	QQQ	ETF	43.37	43.37	43.37	43.37	200.0
2009-10-20 05:00:00	QQQ	ETF	43.34	43.34	43.34	43.34	100.0
2009-10-20 05:30:00	QQQ	ETF	43.43	43.43	43.43	43.43	2000.0
2009-10-20 06:00:00	QQQ	ETF	43.46	43.46	43.41	43.41	1200.0
2009-10-20 06:30:00	QQQ	ETF	43.4	43.45	43.4	43.41	1600.0
2009-10-20 07:00:00	QQQ	ETF	43.42	43.52	43.42	43.52	8274.0
2009-10-20 07:30:00	QQQ	ETF	43.52	43.6	43.48	43.54	92158.0
2009-10-20 08:00:00	QQQ	ETF	43.54	43.58	43.48	43.52	492835.0
2009-10-20 08:30:00	QQQ	ETF	43.47	43.52	43.21	43.21	973156.0
2009-10-20 09:00:00	QQQ	ETF	43.47	43.55	43.45	43.45	673948.0
2009-10-20 09:30:00	QQQ	ETF	43.45	43.46	43.16	43.32	20027302.0
2009-10-20 10:00:00	QQQ	ETF	43.32	43.4	43.13	43.24	9620872.0
2009-10-20 10:30:00	QQQ	ETF	43.2377	43.38	43.2	43.3501	4243455.0
2009-10-20 11:00:00	QQQ	ETF	43.35	43.37	43.25	43.29	3211438.0
2009-10-20 11:30:00	QQQ	ETF	43.28	43.3	43.05	43.1	6558936.0
2009-10-20 12:00:00	QQQ	ETF	43.11	43.13	42.97	43.068	5450074.0
2009-10-20 12:30:00	QQQ	ETF	43.0624	43.08	42.94	43.03	5861331.0

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

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