PREVIEW / etf_30min / 2010-12-07

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-12-07.parquet
  size:    285 KB
  rows:    9,554

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-07 04:00:00	SPY	ETF	123.15	123.45	123.15	123.45	1317.0
2010-12-07 04:30:00	SPY	ETF	123.51	123.6	123.51	123.6	1600.0
2010-12-07 05:00:00	SPY	ETF	123.75	123.92	123.74	123.83	6050.0
2010-12-07 05:30:00	SPY	ETF	123.83	123.89	123.83	123.84	2700.0
2010-12-07 06:00:00	SPY	ETF	123.83	123.87	123.72	123.85	9600.0
2010-12-07 06:30:00	SPY	ETF	123.9	123.9	123.68	123.77	96970.0
2010-12-07 07:00:00	SPY	ETF	123.77	123.88	123.73	123.74	262356.0
2010-12-07 07:30:00	SPY	ETF	123.76	123.9	123.71	123.8	395872.0
2010-12-07 08:00:00	SPY	ETF	123.78	123.9	123.52	123.84	2666207.0
2010-12-07 08:30:00	SPY	ETF	123.85	123.97	123.82	123.93	1182049.0
2010-12-07 09:00:00	SPY	ETF	123.93	124.01	122.7597	123.93	2015934.0
2010-12-07 09:30:00	SPY	ETF	123.94	124.01	123.61	123.62	24199766.0
2010-12-07 10:00:00	SPY	ETF	123.62	123.67	123.41	123.44	15968787.0
2010-12-07 10:30:00	SPY	ETF	123.44	123.62	123.3	123.54	11929832.0
2010-12-07 11:00:00	SPY	ETF	123.54	123.6	123.35	123.41	9510670.0
2010-12-07 11:30:00	SPY	ETF	123.41	123.52	123.31	123.37	8986840.0
2010-12-07 12:00:00	SPY	ETF	123.37	123.43	123.18	123.36	9271652.0
2010-12-07 12:30:00	SPY	ETF	123.35	123.49	123.3	123.47	5155263.0
2010-12-07 13:00:00	SPY	ETF	123.46	123.6	123.42	123.57	7911476.0
2010-12-07 13:30:00	SPY	ETF	123.57	123.68	123.45	123.55	6866600.0
2010-12-07 14:00:00	SPY	ETF	123.56	123.65	123.48	123.62	6827155.0
2010-12-07 14:30:00	SPY	ETF	123.62	123.82	123.12	123.19	17498692.0
2010-12-07 15:00:00	SPY	ETF	123.19	123.29	122.85	123.06	24814804.0
2010-12-07 15:30:00	SPY	ETF	123.06	123.225	122.76	122.83	26221966.0
2010-12-07 16:00:00	SPY	ETF	122.83	123.91	122.72	122.74	13319405.0
2010-12-07 16:30:00	SPY	ETF	122.75	122.8	122.66	122.67	5982018.0
2010-12-07 17:00:00	SPY	ETF	122.66	122.7597	122.46	122.46	1836865.0
2010-12-07 17:30:00	SPY	ETF	122.47	122.61	122.44	122.58	2122916.0
2010-12-07 18:00:00	SPY	ETF	122.55	122.75	122.46	122.73	154323.0
2010-12-07 18:30:00	SPY	ETF	122.73	122.73	122.65	122.69	32790.0
2010-12-07 19:00:00	SPY	ETF	122.71	122.79	122.68	122.79	23819.0
2010-12-07 19:30:00	SPY	ETF	122.78	122.89	122.75	122.84	97954.0
2010-12-07 04:00:00	QQQ	ETF	54.0	54.0	54.0	54.0	300.0
2010-12-07 04:30:00	QQQ	ETF	54.27	54.27	54.27	54.27	700.0
2010-12-07 05:00:00	QQQ	ETF	54.32	54.37	54.32	54.35	600.0
2010-12-07 05:30:00	QQQ	ETF	54.34	54.38	54.3	54.37	6800.0
2010-12-07 06:00:00	QQQ	ETF	54.36	54.39	54.35	54.35	1282.0
2010-12-07 06:30:00	QQQ	ETF	54.36	54.4	54.32	54.33	95400.0
2010-12-07 07:00:00	QQQ	ETF	54.34	54.39	54.32	54.33	74685.0
2010-12-07 07:30:00	QQQ	ETF	54.31	54.39	54.31	54.38	79338.0
2010-12-07 08:00:00	QQQ	ETF	54.35	54.43	54.32	54.43	764399.0
2010-12-07 08:30:00	QQQ	ETF	54.43	54.52	54.43	54.5	221746.0
2010-12-07 09:00:00	QQQ	ETF	54.5	54.53	54.45	54.5	617096.0
2010-12-07 09:30:00	QQQ	ETF	54.49	54.5	54.27	54.27	8197068.0
2010-12-07 10:00:00	QQQ	ETF	54.27	54.2725	54.12	54.16	5452566.0
2010-12-07 10:30:00	QQQ	ETF	54.16	54.259	54.08	54.2199	3384215.0
2010-12-07 11:00:00	QQQ	ETF	54.22	54.245	54.13	54.15	2572844.0
2010-12-07 11:30:00	QQQ	ETF	54.15	54.23	54.13	54.16	1767654.0
2010-12-07 12:00:00	QQQ	ETF	54.169	54.1875	54.1	54.16	1922673.0
2010-12-07 12:30:00	QQQ	ETF	54.1599	54.19	54.13	54.18	899295.0

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

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