PREVIEW / etf_30min / 2010-12-27

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-12-27.parquet
  size:    254 KB
  rows:    8,419

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-12-27 04:00:00	SPY	ETF	125.35	125.35	125.1	125.12	1600.0
2010-12-27 04:30:00	SPY	ETF	125.07	125.15	125.07	125.09	1764.0
2010-12-27 05:00:00	SPY	ETF	125.09	125.11	125.09	125.11	300.0
2010-12-27 05:30:00	SPY	ETF	125.12	125.12	125.12	125.12	200.0
2010-12-27 06:00:00	SPY	ETF	125.2	125.33	125.2	125.33	400.0
2010-12-27 07:00:00	SPY	ETF	125.21	125.23	125.12	125.17	10815.0
2010-12-27 07:30:00	SPY	ETF	125.16	125.16	125.0	125.05	82825.0
2010-12-27 08:00:00	SPY	ETF	125.05	125.14	125.03	125.12	220901.0
2010-12-27 08:30:00	SPY	ETF	125.11	125.19	125.07	125.14	299530.0
2010-12-27 09:00:00	SPY	ETF	125.15	125.2	125.11	125.13	475772.0
2010-12-27 09:30:00	SPY	ETF	125.13	125.24	125.04	125.185	10250476.0
2010-12-27 10:00:00	SPY	ETF	125.18	125.45	125.15	125.44	5567329.0
2010-12-27 10:30:00	SPY	ETF	125.44	125.45	125.33	125.36	4680409.0
2010-12-27 11:00:00	SPY	ETF	125.37	125.4	125.34	125.37	2810230.0
2010-12-27 11:30:00	SPY	ETF	125.375	125.41	125.33	125.39	2784553.0
2010-12-27 12:00:00	SPY	ETF	125.39	125.48	125.38	125.47	2134862.0
2010-12-27 12:30:00	SPY	ETF	125.4784	125.51	125.44	125.47	1486809.0
2010-12-27 13:00:00	SPY	ETF	125.48	125.7	125.46	125.6601	5551358.0
2010-12-27 13:30:00	SPY	ETF	125.67	125.72	125.64	125.72	2690684.0
2010-12-27 14:00:00	SPY	ETF	125.72	125.72	125.62	125.64	4277304.0
2010-12-27 14:30:00	SPY	ETF	125.64	125.74	125.63	125.67	2692637.0
2010-12-27 15:00:00	SPY	ETF	125.675	125.76	125.65	125.71	2550113.0
2010-12-27 15:30:00	SPY	ETF	125.71	125.77	125.66	125.66	6403502.0
2010-12-27 16:00:00	SPY	ETF	125.67	125.75	125.115	125.7	2945850.0
2010-12-27 16:30:00	SPY	ETF	125.71	125.71	125.66	125.7	153398.0
2010-12-27 17:00:00	SPY	ETF	125.7	125.7	125.68	125.7	12500.0
2010-12-27 17:30:00	SPY	ETF	125.68	125.71	125.68	125.71	2500.0
2010-12-27 18:00:00	SPY	ETF	125.72	125.72	125.68	125.72	15102.0
2010-12-27 18:30:00	SPY	ETF	125.72	125.72	125.7	125.7	5270.0
2010-12-27 19:00:00	SPY	ETF	125.72	125.74	125.71	125.74	18097.0
2010-12-27 19:30:00	SPY	ETF	125.74	125.8	125.74	125.77	25200.0
2010-12-27 04:00:00	QQQ	ETF	54.57	54.6	54.57	54.6	350.0
2010-12-27 07:00:00	QQQ	ETF	54.68	54.68	54.64	54.66	3936.0
2010-12-27 07:30:00	QQQ	ETF	54.66	54.66	54.57	54.59	19874.0
2010-12-27 08:00:00	QQQ	ETF	54.58	54.63	54.58	54.62	68069.0
2010-12-27 08:30:00	QQQ	ETF	54.61	54.62	54.6	54.61	93050.0
2010-12-27 09:00:00	QQQ	ETF	54.62	54.65	54.6	54.61	104666.0
2010-12-27 09:30:00	QQQ	ETF	54.62	54.63	54.21	54.24	5403726.0
2010-12-27 10:00:00	QQQ	ETF	54.235	54.42	54.23	54.4	1944592.0
2010-12-27 10:30:00	QQQ	ETF	54.4	54.43	54.35	54.35	3313118.0
2010-12-27 11:00:00	QQQ	ETF	54.355	54.42	54.35	54.381	838398.0
2010-12-27 11:30:00	QQQ	ETF	54.3872	54.42	54.37	54.419	661287.0
2010-12-27 12:00:00	QQQ	ETF	54.417	54.53	54.41	54.52	1055377.0
2010-12-27 12:30:00	QQQ	ETF	54.525	54.53	54.49	54.52	487993.0
2010-12-27 13:00:00	QQQ	ETF	54.5199	54.83	54.51	54.8062	2648806.0
2010-12-27 13:30:00	QQQ	ETF	54.8	54.86	54.8	54.82	1535355.0
2010-12-27 14:00:00	QQQ	ETF	54.82	54.8281	54.78	54.8	950418.0
2010-12-27 14:30:00	QQQ	ETF	54.8	54.83	54.79	54.8	843699.0
2010-12-27 15:00:00	QQQ	ETF	54.8	54.83	54.78	54.81	1358550.0
2010-12-27 15:30:00	QQQ	ETF	54.81	54.82	54.75	54.75	2583894.0

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

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