PREVIEW / etf_30min / 2010-05-14

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-05-14.parquet
  size:    266 KB
  rows:    8,844

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-14 04:00:00	SPY	ETF	115.75	115.75	115.48	115.48	540.0
2010-05-14 04:30:00	SPY	ETF	115.44	115.44	115.44	115.44	100.0
2010-05-14 05:00:00	SPY	ETF	115.47	115.47	115.21	115.4	29600.0
2010-05-14 05:30:00	SPY	ETF	115.23	115.23	115.08	115.08	2870.0
2010-05-14 06:00:00	SPY	ETF	115.2	115.35	115.1	115.35	23232.0
2010-05-14 06:30:00	SPY	ETF	115.25	115.4	115.16	115.38	23520.0
2010-05-14 07:00:00	SPY	ETF	115.42	115.54	115.31	115.39	505327.0
2010-05-14 07:30:00	SPY	ETF	115.41	115.53	115.25	115.27	482319.0
2010-05-14 08:00:00	SPY	ETF	115.26	115.34	114.99	115.15	3475557.0
2010-05-14 08:30:00	SPY	ETF	115.16	115.48	114.91	115.25	3312860.0
2010-05-14 09:00:00	SPY	ETF	115.24	115.26	114.88	115.12	3551151.0
2010-05-14 09:30:00	SPY	ETF	115.12	115.33	113.98	114.24	50206079.0
2010-05-14 10:00:00	SPY	ETF	114.23	114.68	113.73	114.39	29605402.0
2010-05-14 10:30:00	SPY	ETF	114.39	114.49	113.94	114.1795	15325707.0
2010-05-14 11:00:00	SPY	ETF	114.17	114.19	113.07	113.461	38163455.0
2010-05-14 11:30:00	SPY	ETF	113.47	113.77	113.24	113.38	18589374.0
2010-05-14 12:00:00	SPY	ETF	113.38	113.57	112.87	113.36	21507877.0
2010-05-14 12:30:00	SPY	ETF	113.36	113.83	113.3	113.77	12314007.0
2010-05-14 13:00:00	SPY	ETF	113.77	113.94	113.37	113.51	13703782.0
2010-05-14 13:30:00	SPY	ETF	113.51	113.66	113.19	113.46	14730278.0
2010-05-14 14:00:00	SPY	ETF	113.46	113.57	112.95	113.33	17744255.0
2010-05-14 14:30:00	SPY	ETF	113.34	113.64	113.2	113.29	18473675.0
2010-05-14 15:00:00	SPY	ETF	113.28	113.5	112.91	113.18	18997399.0
2010-05-14 15:30:00	SPY	ETF	113.18	114.12	113.06	113.9	43791139.0
2010-05-14 16:00:00	SPY	ETF	113.9	116.0329	113.13	114.05	18395615.0
2010-05-14 16:30:00	SPY	ETF	114.04	114.11	113.99	114.01	393522.0
2010-05-14 17:00:00	SPY	ETF	114.0	114.04	113.82	113.85	352655.0
2010-05-14 17:30:00	SPY	ETF	113.85	114.0	113.79	113.9	188084.0
2010-05-14 18:00:00	SPY	ETF	113.85	113.94	113.85	113.93	13286.0
2010-05-14 18:30:00	SPY	ETF	113.93	114.04	113.83	113.97	21834.0
2010-05-14 19:00:00	SPY	ETF	113.91	113.99	113.91	113.94	5725.0
2010-05-14 19:30:00	SPY	ETF	113.94	113.97	113.86	113.95	24709.0
2010-05-14 04:00:00	QQQ	ETF	47.79	47.79	47.79	47.79	100.0
2010-05-14 04:30:00	QQQ	ETF	47.74	47.74	47.74	47.74	3600.0
2010-05-14 05:00:00	QQQ	ETF	47.65	47.65	47.65	47.65	20100.0
2010-05-14 05:30:00	QQQ	ETF	47.61	47.61	47.6	47.6	800.0
2010-05-14 06:00:00	QQQ	ETF	47.63	47.63	47.57	47.57	400.0
2010-05-14 07:00:00	QQQ	ETF	47.7	47.72	47.63	47.67	29950.0
2010-05-14 07:30:00	QQQ	ETF	47.66	47.72	47.62	47.64	39289.0
2010-05-14 08:00:00	QQQ	ETF	47.63	47.65	47.51	47.54	1407887.0
2010-05-14 08:30:00	QQQ	ETF	47.55	47.65	47.45	47.57	2372649.0
2010-05-14 09:00:00	QQQ	ETF	47.56	47.58	47.46	47.48	1803089.0
2010-05-14 09:30:00	QQQ	ETF	47.49	47.52	46.82	46.85	25253523.0
2010-05-14 10:00:00	QQQ	ETF	46.86	47.14	46.72	47.02	11225906.0
2010-05-14 10:30:00	QQQ	ETF	47.02	47.0762	46.88	46.97	5096030.0
2010-05-14 11:00:00	QQQ	ETF	46.96	46.96	46.48	46.64	13130305.0
2010-05-14 11:30:00	QQQ	ETF	46.62	46.71	46.5	46.55	8314873.0
2010-05-14 12:00:00	QQQ	ETF	46.55	46.67	46.38	46.56	7691675.0
2010-05-14 12:30:00	QQQ	ETF	46.5526	46.75	46.52	46.74	10030128.0
2010-05-14 13:00:00	QQQ	ETF	46.74	46.79	46.62	46.7	4047318.0

> showing 50 of 8,844 rows — these rows as CSV

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