PREVIEW / etf_30min / 2010-03-19

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-03-19.parquet
  size:    245 KB
  rows:    8,180

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-03-19 04:00:00	SPY	ETF	117.09	117.09	116.9	116.9	13426.0
2010-03-19 04:30:00	SPY	ETF	116.74	116.74	116.24	116.53	12056.0
2010-03-19 05:00:00	SPY	ETF	116.63	116.63	116.63	116.63	100.0
2010-03-19 05:30:00	SPY	ETF	116.58	116.62	116.58	116.6	1975.0
2010-03-19 06:00:00	SPY	ETF	116.57	116.6	116.57	116.6	500.0
2010-03-19 06:30:00	SPY	ETF	116.72	116.72	116.65	116.65	950.0
2010-03-19 07:00:00	SPY	ETF	116.69	116.69	116.55	116.57	78650.0
2010-03-19 07:30:00	SPY	ETF	116.57	116.64	116.5	116.63	153750.0
2010-03-19 08:00:00	SPY	ETF	116.65	116.71	116.6	116.66	1494203.0
2010-03-19 08:30:00	SPY	ETF	116.64	116.8	116.61	116.8	643885.0
2010-03-19 09:00:00	SPY	ETF	116.8	116.95	116.72	116.94	1041287.0
2010-03-19 09:30:00	SPY	ETF	116.96	116.97	116.52	116.62	27883842.0
2010-03-19 10:00:00	SPY	ETF	116.63	116.64	116.05	116.12	23308562.0
2010-03-19 10:30:00	SPY	ETF	116.13	117.293	115.94	116.06	14551702.0
2010-03-19 11:00:00	SPY	ETF	116.06	116.6	115.66	115.79	19009291.0
2010-03-19 11:30:00	SPY	ETF	115.79	115.97	115.7	115.9	12254706.0
2010-03-19 12:00:00	SPY	ETF	115.9079	116.0	115.74	115.85	11788721.0
2010-03-19 12:30:00	SPY	ETF	115.85	115.92	115.78	115.84	7519143.0
2010-03-19 13:00:00	SPY	ETF	115.84	115.97	115.82	115.91	4815940.0
2010-03-19 13:30:00	SPY	ETF	115.92	115.95	115.72	115.92	7628324.0
2010-03-19 14:00:00	SPY	ETF	115.93	116.09	115.85	116.04	10394836.0
2010-03-19 14:30:00	SPY	ETF	116.04	116.04	115.83	115.84	8277705.0
2010-03-19 15:00:00	SPY	ETF	115.84	115.95	115.82	115.85	9020884.0
2010-03-19 15:30:00	SPY	ETF	115.85	116.5762	115.52	115.96	42313052.0
2010-03-19 16:00:00	SPY	ETF	115.97	116.95	115.75	116.0	11366142.0
2010-03-19 16:30:00	SPY	ETF	116.0	116.5762	115.96	115.99	9604075.0
2010-03-19 17:00:00	SPY	ETF	115.98	116.0	115.95	115.97	443663.0
2010-03-19 17:30:00	SPY	ETF	116.5762	116.5762	115.91	115.98	2076553.0
2010-03-19 18:00:00	SPY	ETF	115.98	115.98	115.91	115.91	56115.0
2010-03-19 18:30:00	SPY	ETF	115.91	115.93	115.9	115.91	29260.0
2010-03-19 19:00:00	SPY	ETF	115.91	115.94	115.9	115.9	10725.0
2010-03-19 19:30:00	SPY	ETF	115.9	115.93	115.88	115.93	25808.0
2010-03-19 05:00:00	QQQ	ETF	47.75	47.75	47.75	47.75	600.0
2010-03-19 07:00:00	QQQ	ETF	47.81	47.81	47.78	47.78	78298.0
2010-03-19 07:30:00	QQQ	ETF	47.78	47.83	47.76	47.82	55752.0
2010-03-19 08:00:00	QQQ	ETF	47.81	47.86	47.72	47.84	935719.0
2010-03-19 08:30:00	QQQ	ETF	47.84	47.93	47.83	47.92	1561861.0
2010-03-19 09:00:00	QQQ	ETF	47.92	47.96	47.87	47.95	757505.0
2010-03-19 09:30:00	QQQ	ETF	47.95	47.95	47.72	47.77	19136994.0
2010-03-19 10:00:00	QQQ	ETF	47.76	47.77	47.52	47.56	9448343.0
2010-03-19 10:30:00	QQQ	ETF	47.56	47.59	47.45	47.51	6984419.0
2010-03-19 11:00:00	QQQ	ETF	47.5162	47.53	47.38	47.43	6038800.0
2010-03-19 11:30:00	QQQ	ETF	47.435	47.53	47.41	47.5	5319372.0
2010-03-19 12:00:00	QQQ	ETF	47.5	47.55	47.41	47.46	3472356.0
2010-03-19 12:30:00	QQQ	ETF	47.46	47.49	47.39	47.43	2117018.0
2010-03-19 13:00:00	QQQ	ETF	47.43	47.47	47.42	47.4599	1832020.0
2010-03-19 13:30:00	QQQ	ETF	47.4526	47.48	47.4	47.47	2351691.0
2010-03-19 14:00:00	QQQ	ETF	47.4699	47.53	47.45	47.51	2224291.0
2010-03-19 14:30:00	QQQ	ETF	47.51	47.51	47.44	47.45	3059554.0
2010-03-19 15:00:00	QQQ	ETF	47.4501	47.51	47.44	47.4401	3134451.0

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

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