PREVIEW / etf_30min / 2010-01-14

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-01-14.parquet
  size:    236 KB
  rows:    7,981

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-01-14 05:00:00	SPY	ETF	114.67	114.67	114.59	114.6	2900.0
2010-01-14 06:00:00	SPY	ETF	114.55	114.55	114.55	114.55	200.0
2010-01-14 06:30:00	SPY	ETF	114.53	114.6	114.53	114.6	1100.0
2010-01-14 07:00:00	SPY	ETF	114.61	114.64	114.55	114.56	15190.0
2010-01-14 07:30:00	SPY	ETF	114.57	114.63	114.41	114.63	137800.0
2010-01-14 08:00:00	SPY	ETF	114.62	114.79	114.59	114.7	686444.0
2010-01-14 08:30:00	SPY	ETF	114.69	114.7	114.27	114.31	2792303.0
2010-01-14 09:00:00	SPY	ETF	114.32	114.5	114.31	114.49	1005080.0
2010-01-14 09:30:00	SPY	ETF	114.49	114.71	114.42	114.62	13560579.0
2010-01-14 10:00:00	SPY	ETF	114.61	114.99	114.6	114.83	10703233.0
2010-01-14 10:30:00	SPY	ETF	114.81	114.93	114.56	114.57	10005775.0
2010-01-14 11:00:00	SPY	ETF	114.58	114.67	114.44	114.63	9223017.0
2010-01-14 11:30:00	SPY	ETF	114.63	114.78	114.59	114.63	4940127.0
2010-01-14 12:00:00	SPY	ETF	114.63	114.75	114.61	114.72	2993757.0
2010-01-14 12:30:00	SPY	ETF	114.72	114.83	114.7	114.76	4395491.0
2010-01-14 13:00:00	SPY	ETF	114.76	114.79	114.71	114.75	3459123.0
2010-01-14 13:30:00	SPY	ETF	114.76	114.92	114.75	114.85	5099447.0
2010-01-14 14:00:00	SPY	ETF	114.85	114.92	114.81	114.86	3615555.0
2010-01-14 14:30:00	SPY	ETF	114.85	115.01	114.83	114.94	8931167.0
2010-01-14 15:00:00	SPY	ETF	114.9417	115.14	114.94	114.9975	13148489.0
2010-01-14 15:30:00	SPY	ETF	115.0	115.07	114.85	114.92	12274180.0
2010-01-14 16:00:00	SPY	ETF	114.92	115.25	114.49	115.11	5597114.0
2010-01-14 16:30:00	SPY	ETF	115.11	115.15	114.6384	115.13	2470408.0
2010-01-14 17:00:00	SPY	ETF	115.1	115.15	115.1	115.12	86922.0
2010-01-14 17:30:00	SPY	ETF	115.14	115.15	115.07	115.08	52650.0
2010-01-14 18:00:00	SPY	ETF	115.08	115.08	114.99	115.03	85760.0
2010-01-14 18:30:00	SPY	ETF	115.0	115.0	114.91	114.95	23625.0
2010-01-14 19:00:00	SPY	ETF	114.94	115.0	114.91	114.98	13800.0
2010-01-14 19:30:00	SPY	ETF	114.98	115.05	114.97	115.0	13614.0
2010-01-14 04:00:00	QQQ	ETF	46.35	46.35	46.35	46.35	160.0
2010-01-14 06:30:00	QQQ	ETF	46.26	46.28	46.26	46.28	21000.0
2010-01-14 07:00:00	QQQ	ETF	46.3	46.31	46.27	46.27	11470.0
2010-01-14 07:30:00	QQQ	ETF	46.28	46.31	46.23	46.31	42187.0
2010-01-14 08:00:00	QQQ	ETF	46.31	46.38	46.19	46.34	609912.0
2010-01-14 08:30:00	QQQ	ETF	46.32	46.38	46.17	46.2	880099.0
2010-01-14 09:00:00	QQQ	ETF	46.2	46.28	46.19	46.27	415146.0
2010-01-14 09:30:00	QQQ	ETF	46.26	46.41	46.22	46.322	10813483.0
2010-01-14 10:00:00	QQQ	ETF	46.33	46.5	46.32	46.4	6422190.0
2010-01-14 10:30:00	QQQ	ETF	46.4	46.465	46.26	46.28	7577784.0
2010-01-14 11:00:00	QQQ	ETF	46.27	46.36	46.22	46.33	4552233.0
2010-01-14 11:30:00	QQQ	ETF	46.33	46.38	46.275	46.29	3242250.0
2010-01-14 12:00:00	QQQ	ETF	46.3	46.4	46.29	46.39	1610274.0
2010-01-14 12:30:00	QQQ	ETF	46.39	46.43	46.34	46.375	3588969.0
2010-01-14 13:00:00	QQQ	ETF	46.38	46.39	46.32	46.34	2565307.0
2010-01-14 13:30:00	QQQ	ETF	46.34	46.41	46.335	46.3699	2699369.0
2010-01-14 14:00:00	QQQ	ETF	46.365	46.42	46.2898	46.4	2175217.0
2010-01-14 14:30:00	QQQ	ETF	46.39	46.46	46.38	46.44	4632208.0
2010-01-14 15:00:00	QQQ	ETF	46.44	46.52	46.44	46.47	5026067.0
2010-01-14 15:30:00	QQQ	ETF	46.46	46.48	46.37	46.38	8647469.0
2010-01-14 16:00:00	QQQ	ETF	46.38	46.78	46.2898	46.61	7269794.0

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

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