PREVIEW / etf_30min / 2010-05-20

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-05-20.parquet
  size:    294 KB
  rows:    9,778

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
2010-05-20 04:00:00	SPY	ETF	111.71	111.71	111.66	111.7	3500.0
2010-05-20 05:00:00	SPY	ETF	111.51	111.51	111.49	111.49	1400.0
2010-05-20 05:30:00	SPY	ETF	111.35	111.35	111.35	111.35	500.0
2010-05-20 06:00:00	SPY	ETF	111.32	111.34	111.21	111.29	8500.0
2010-05-20 06:30:00	SPY	ETF	111.25	111.25	110.75	110.88	131950.0
2010-05-20 07:00:00	SPY	ETF	110.87	110.98	109.68	110.03	1344329.0
2010-05-20 07:30:00	SPY	ETF	110.04	110.19	109.42	109.87	3150790.0
2010-05-20 08:00:00	SPY	ETF	109.86	110.17	109.6	109.84	3457339.0
2010-05-20 08:30:00	SPY	ETF	109.78	112.08	109.02	109.38	6643947.0
2010-05-20 09:00:00	SPY	ETF	109.37	111.6	109.33	109.39	3909910.0
2010-05-20 09:30:00	SPY	ETF	109.38	109.89	109.12	109.54	56596497.0
2010-05-20 10:00:00	SPY	ETF	109.53	109.7683	107.95	108.457	52318056.0
2010-05-20 10:30:00	SPY	ETF	108.45	109.11	108.35	108.8	31965052.0
2010-05-20 11:00:00	SPY	ETF	108.79	109.35	108.62	109.3299	28254816.0
2010-05-20 11:30:00	SPY	ETF	109.32	109.46	108.82	108.84	20291725.0
2010-05-20 12:00:00	SPY	ETF	108.85	109.13	108.47	108.57	18146492.0
2010-05-20 12:30:00	SPY	ETF	108.5601	108.68	107.65	107.68	23622064.0
2010-05-20 13:00:00	SPY	ETF	107.68	109.1	107.61	108.84	36770855.0
2010-05-20 13:30:00	SPY	ETF	108.85	109.29	108.56	108.72	31530908.0
2010-05-20 14:00:00	SPY	ETF	108.73	109.45	108.13	109.0	28891524.0
2010-05-20 14:30:00	SPY	ETF	109.0	109.88	108.81	109.13	44035212.0
2010-05-20 15:00:00	SPY	ETF	109.12	109.39	108.73	109.08	29385936.0
2010-05-20 15:30:00	SPY	ETF	109.09	109.29	107.48	107.538	63882633.0
2010-05-20 16:00:00	SPY	ETF	107.5	111.8565	107.25	107.4	26441590.0
2010-05-20 16:30:00	SPY	ETF	107.4	107.55	106.83	107.05	6514348.0
2010-05-20 17:00:00	SPY	ETF	107.06	111.8565	106.8	107.0	8582852.0
2010-05-20 17:30:00	SPY	ETF	107.0	107.04	106.7	106.79	2381532.0
2010-05-20 18:00:00	SPY	ETF	106.79	107.55	106.76	106.82	713981.0
2010-05-20 18:30:00	SPY	ETF	106.89	107.22	106.77	106.91	193682.0
2010-05-20 19:00:00	SPY	ETF	106.92	107.03	106.69	106.83	175902.0
2010-05-20 19:30:00	SPY	ETF	106.89	107.24	106.69	107.2	222771.0
2010-05-20 04:00:00	QQQ	ETF	45.99	45.99	45.99	45.99	1023.0
2010-05-20 05:00:00	QQQ	ETF	45.97	45.97	45.97	45.97	1000.0
2010-05-20 05:30:00	QQQ	ETF	45.93	45.93	45.93	45.93	500.0
2010-05-20 06:00:00	QQQ	ETF	45.82	45.82	45.82	45.82	500.0
2010-05-20 06:30:00	QQQ	ETF	45.69	45.69	45.6	45.65	3400.0
2010-05-20 07:00:00	QQQ	ETF	45.66	45.69	45.23	45.36	93542.0
2010-05-20 07:30:00	QQQ	ETF	45.35	45.43	45.13	45.32	463306.0
2010-05-20 08:00:00	QQQ	ETF	45.32	45.44	45.21	45.31	456633.0
2010-05-20 08:30:00	QQQ	ETF	45.25	45.27	45.04	45.11	1268334.0
2010-05-20 09:00:00	QQQ	ETF	45.12	45.86	45.11	45.17	1759047.0
2010-05-20 09:30:00	QQQ	ETF	45.17	45.27	44.98	45.1	18413458.0
2010-05-20 10:00:00	QQQ	ETF	45.102	45.23	44.4	44.68	25200928.0
2010-05-20 10:30:00	QQQ	ETF	44.68	44.88	44.57	44.75	12959133.0
2010-05-20 11:00:00	QQQ	ETF	44.75	44.96	44.67	44.95	10415362.0
2010-05-20 11:30:00	QQQ	ETF	44.95	45.01	44.78	44.81	7235338.0
2010-05-20 12:00:00	QQQ	ETF	44.81	44.88	44.62	44.67	5936254.0
2010-05-20 12:30:00	QQQ	ETF	44.68	44.7	44.25	44.28	8973093.0
2010-05-20 13:00:00	QQQ	ETF	44.27	44.84	44.26	44.75	11421011.0
2010-05-20 13:30:00	QQQ	ETF	44.75	44.95	44.65	44.73	10807761.0

> showing 50 of 9,778 rows — these rows as CSV

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