PREVIEW / etf_30min / 2010-10-15

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-10-15.parquet
  size:    262 KB
  rows:    8,869

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-10-15 04:00:00	SPY	ETF	117.8	117.8	117.6	117.77	2400.0
2010-10-15 05:00:00	SPY	ETF	117.75	117.75	117.75	117.75	500.0
2010-10-15 05:30:00	SPY	ETF	117.78	117.78	117.62	117.62	1000.0
2010-10-15 06:00:00	SPY	ETF	117.75	117.75	117.6	117.68	9000.0
2010-10-15 06:30:00	SPY	ETF	117.62	117.66	117.55	117.62	96810.0
2010-10-15 07:00:00	SPY	ETF	117.64	117.69	117.48	117.5	688695.0
2010-10-15 07:30:00	SPY	ETF	117.5	117.71	117.48	117.65	399714.0
2010-10-15 08:00:00	SPY	ETF	117.65	118.29	117.49	118.1	3702750.0
2010-10-15 08:30:00	SPY	ETF	118.08	118.44	117.87	118.05	3430511.0
2010-10-15 09:00:00	SPY	ETF	118.04	118.4	117.88	118.29	3909586.0
2010-10-15 09:30:00	SPY	ETF	118.28	118.35	117.5	117.54	30305626.0
2010-10-15 10:00:00	SPY	ETF	117.55	117.75	116.76	116.98	34179526.0
2010-10-15 10:30:00	SPY	ETF	116.98	117.39	116.81	117.28	17615294.0
2010-10-15 11:00:00	SPY	ETF	117.29	117.66	117.26	117.55	14139847.0
2010-10-15 11:30:00	SPY	ETF	117.55	117.83	117.21	117.31	18447517.0
2010-10-15 12:00:00	SPY	ETF	117.31	117.51	117.1	117.5	15268496.0
2010-10-15 12:30:00	SPY	ETF	117.5	117.7	117.41	117.475	9071637.0
2010-10-15 13:00:00	SPY	ETF	117.48	117.59	117.42	117.55	6558995.0
2010-10-15 13:30:00	SPY	ETF	117.56	117.61	117.23	117.33	11031621.0
2010-10-15 14:00:00	SPY	ETF	117.32	117.6	117.1681	117.59	12335717.0
2010-10-15 14:30:00	SPY	ETF	117.585	117.72	117.4	117.538	8794219.0
2010-10-15 15:00:00	SPY	ETF	117.53	117.54	117.3	117.41	13810767.0
2010-10-15 15:30:00	SPY	ETF	117.41	117.79	117.34	117.73	24019054.0
2010-10-15 16:00:00	SPY	ETF	117.72	118.02	116.65	117.96	11296386.0
2010-10-15 16:30:00	SPY	ETF	117.97	118.02	117.4169	117.98	426495.0
2010-10-15 17:00:00	SPY	ETF	117.98	117.98	117.91	117.93	107778.0
2010-10-15 17:30:00	SPY	ETF	117.92	117.92	117.88	117.91	74762.0
2010-10-15 18:00:00	SPY	ETF	117.91	117.92	117.72	117.87	116934.0
2010-10-15 18:30:00	SPY	ETF	117.92	117.93	117.88	117.88	7429.0
2010-10-15 19:00:00	SPY	ETF	117.89	117.93	117.79	117.89	47579.0
2010-10-15 19:30:00	SPY	ETF	117.9	117.9	117.85	117.85	6630.0
2010-10-15 04:00:00	QQQ	ETF	50.72	50.78	50.72	50.78	780.0
2010-10-15 05:00:00	QQQ	ETF	50.77	50.77	50.77	50.77	100.0
2010-10-15 05:30:00	QQQ	ETF	50.73	50.73	50.73	50.73	800.0
2010-10-15 06:00:00	QQQ	ETF	50.76	50.76	50.74	50.74	2500.0
2010-10-15 06:30:00	QQQ	ETF	50.75	50.75	50.75	50.75	1100.0
2010-10-15 07:00:00	QQQ	ETF	50.73	50.75	50.66	50.66	316380.0
2010-10-15 07:30:00	QQQ	ETF	50.67	50.75	50.64	50.74	360716.0
2010-10-15 08:00:00	QQQ	ETF	50.67	51.0	50.67	50.87	1046380.0
2010-10-15 08:30:00	QQQ	ETF	50.86	51.05	50.85	50.9	827586.0
2010-10-15 09:00:00	QQQ	ETF	50.9	51.1	50.82	51.05	808362.0
2010-10-15 09:30:00	QQQ	ETF	51.04	51.13	50.76	50.86	11680871.0
2010-10-15 10:00:00	QQQ	ETF	50.86	50.94	50.66	50.73	11526127.0
2010-10-15 10:30:00	QQQ	ETF	50.72	50.9	50.63	50.855	5253232.0
2010-10-15 11:00:00	QQQ	ETF	50.85	51.08	50.83	51.05	7165806.0
2010-10-15 11:30:00	QQQ	ETF	51.05	51.22	51.01	51.045	10862324.0
2010-10-15 12:00:00	QQQ	ETF	51.045	51.13	50.945	51.1	5282797.0
2010-10-15 12:30:00	QQQ	ETF	51.1	51.175	51.06	51.1001	3572649.0
2010-10-15 13:00:00	QQQ	ETF	51.11	51.18	51.09	51.17	2131480.0
2010-10-15 13:30:00	QQQ	ETF	51.17	51.21	51.065	51.12	3955454.0

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

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