PREVIEW / etf_30min / 2010-02-04

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-02-04.parquet
  size:    266 KB
  rows:    8,703

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-02-04 04:00:00	SPY	ETF	109.61	109.61	109.29	109.29	4633.0
2010-02-04 04:30:00	SPY	ETF	109.43	109.51	109.42	109.45	3389.0
2010-02-04 05:00:00	SPY	ETF	109.43	109.44	109.3	109.43	86689.0
2010-02-04 05:30:00	SPY	ETF	109.42	109.42	109.21	109.26	2380.0
2010-02-04 06:00:00	SPY	ETF	109.39	109.47	109.39	109.41	12600.0
2010-02-04 06:30:00	SPY	ETF	109.46	109.46	109.36	109.36	43400.0
2010-02-04 07:00:00	SPY	ETF	109.42	109.49	109.31	109.49	62210.0
2010-02-04 07:30:00	SPY	ETF	109.5	109.64	109.44	109.5	527568.0
2010-02-04 08:00:00	SPY	ETF	109.51	109.55	109.36	109.38	923107.0
2010-02-04 08:30:00	SPY	ETF	109.41	109.45	108.95	109.06	6954260.0
2010-02-04 09:00:00	SPY	ETF	109.06	109.08	108.88	108.98	3427626.0
2010-02-04 09:30:00	SPY	ETF	108.98	109.03	107.84	107.95	40152801.0
2010-02-04 10:00:00	SPY	ETF	107.96	108.18	107.51	107.6	32451788.0
2010-02-04 10:30:00	SPY	ETF	107.59	107.88	107.46	107.5	22921439.0
2010-02-04 11:00:00	SPY	ETF	107.5	107.82	107.35	107.76	21070027.0
2010-02-04 11:30:00	SPY	ETF	107.76	107.7725	107.05	107.45	22220666.0
2010-02-04 12:00:00	SPY	ETF	107.45	107.51	107.2	107.33	13231115.0
2010-02-04 12:30:00	SPY	ETF	107.33	107.43	106.95	107.26	20092891.0
2010-02-04 13:00:00	SPY	ETF	107.26	107.37	107.1	107.3099	9248848.0
2010-02-04 13:30:00	SPY	ETF	107.31	107.34	106.94	107.02	18571230.0
2010-02-04 14:00:00	SPY	ETF	107.02	107.38	106.87	107.3	20238230.0
2010-02-04 14:30:00	SPY	ETF	107.2915	107.44	107.2	107.26	13646320.0
2010-02-04 15:00:00	SPY	ETF	107.26	107.32	106.71	106.84	26434065.0
2010-02-04 15:30:00	SPY	ETF	106.83	107.417	106.42	106.47	44537530.0
2010-02-04 16:00:00	SPY	ETF	106.47	108.93	106.44	106.65	14016309.0
2010-02-04 16:30:00	SPY	ETF	106.65	106.73	106.59	106.62	7659537.0
2010-02-04 17:00:00	SPY	ETF	106.62	109.8803	106.59	106.7	3271125.0
2010-02-04 17:30:00	SPY	ETF	106.65	106.7	106.56	106.69	387829.0
2010-02-04 18:00:00	SPY	ETF	106.7	106.85	106.7	106.8	347310.0
2010-02-04 18:30:00	SPY	ETF	106.8	106.81	106.77	106.8	83440.0
2010-02-04 19:00:00	SPY	ETF	106.81	106.84	106.77	106.82	46182.0
2010-02-04 19:30:00	SPY	ETF	106.82	106.83	106.66	106.73	34407.0
2010-02-04 04:00:00	QQQ	ETF	43.83	43.84	43.76	43.76	2500.0
2010-02-04 04:30:00	QQQ	ETF	43.78	43.82	43.78	43.82	400.0
2010-02-04 05:00:00	QQQ	ETF	43.77	43.77	43.77	43.77	300.0
2010-02-04 05:30:00	QQQ	ETF	43.72	43.74	43.71	43.73	2900.0
2010-02-04 06:00:00	QQQ	ETF	43.72	43.74	43.71	43.74	9800.0
2010-02-04 06:30:00	QQQ	ETF	43.77	43.77	43.72	43.73	2900.0
2010-02-04 07:00:00	QQQ	ETF	43.73	43.77	43.71	43.76	42316.0
2010-02-04 07:30:00	QQQ	ETF	43.77	43.83	43.77	43.8	586568.0
2010-02-04 08:00:00	QQQ	ETF	43.81	43.86	43.75	43.8	1028443.0
2010-02-04 08:30:00	QQQ	ETF	43.79	43.82	43.61	43.62	2448435.0
2010-02-04 09:00:00	QQQ	ETF	43.62	43.65	43.55	43.56	542446.0
2010-02-04 09:30:00	QQQ	ETF	43.57	43.66	43.13	43.1599	21203237.0
2010-02-04 10:00:00	QQQ	ETF	43.15	43.26	43.02	43.07	16184180.0
2010-02-04 10:30:00	QQQ	ETF	43.07	43.18	43.0	43.03	10226799.0
2010-02-04 11:00:00	QQQ	ETF	43.0201	43.1	42.98	43.08	7966782.0
2010-02-04 11:30:00	QQQ	ETF	43.0801	43.09	42.79	42.92	7960198.0
2010-02-04 12:00:00	QQQ	ETF	42.9199	42.98	42.87	42.915	4222849.0
2010-02-04 12:30:00	QQQ	ETF	42.92	42.94	42.76	42.865	7593831.0

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

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