PREVIEW / etf_30min / 2010-02-24

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-02-24.parquet
  size:    234 KB
  rows:    7,876

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-24 04:00:00	SPY	ETF	109.86	109.87	109.77	109.79	4300.0
2010-02-24 04:30:00	SPY	ETF	109.86	109.91	109.84	109.91	11545.0
2010-02-24 05:00:00	SPY	ETF	109.99	110.05	109.94	109.97	23600.0
2010-02-24 05:30:00	SPY	ETF	110.06	110.08	110.06	110.08	4000.0
2010-02-24 06:00:00	SPY	ETF	110.04	110.04	109.95	109.95	24000.0
2010-02-24 06:30:00	SPY	ETF	109.95	110.31	109.95	110.29	89530.0
2010-02-24 07:00:00	SPY	ETF	110.21	110.26	110.17	110.21	161202.0
2010-02-24 07:30:00	SPY	ETF	110.2	110.42	110.18	110.34	150619.0
2010-02-24 08:00:00	SPY	ETF	110.33	110.35	109.84	110.3	387073.0
2010-02-24 08:30:00	SPY	ETF	110.32	110.34	110.19	110.27	748148.0
2010-02-24 09:00:00	SPY	ETF	110.28	110.28	110.11	110.14	1323368.0
2010-02-24 09:30:00	SPY	ETF	110.14	110.66	110.12	110.51	17778404.0
2010-02-24 10:00:00	SPY	ETF	110.51	110.51	109.86	110.02	30061607.0
2010-02-24 10:30:00	SPY	ETF	110.01	110.91	109.91	110.75	23598706.0
2010-02-24 11:00:00	SPY	ETF	110.75	110.96	110.53	110.63	13028750.0
2010-02-24 11:30:00	SPY	ETF	110.63	110.8	110.575	110.7	7606499.0
2010-02-24 12:00:00	SPY	ETF	110.7	110.86	110.58	110.71	6514450.0
2010-02-24 12:30:00	SPY	ETF	110.71	110.81	110.63	110.68	4403942.0
2010-02-24 13:00:00	SPY	ETF	110.68	111.0	110.595	110.86	8659241.0
2010-02-24 13:30:00	SPY	ETF	110.86	110.95	110.73	110.86	4009211.0
2010-02-24 14:00:00	SPY	ETF	110.86	110.87	110.64	110.69	6159889.0
2010-02-24 14:30:00	SPY	ETF	110.69	110.7	110.37	110.5	12607934.0
2010-02-24 15:00:00	SPY	ETF	110.49	110.71	110.47	110.625	7968541.0
2010-02-24 15:30:00	SPY	ETF	110.625	110.89	110.55	110.82	19575748.0
2010-02-24 16:00:00	SPY	ETF	110.82	110.86	110.0153	110.81	6205406.0
2010-02-24 16:30:00	SPY	ETF	110.78	110.86	109.7966	110.73	4161415.0
2010-02-24 17:00:00	SPY	ETF	110.73	110.77	110.73	110.74	78353.0
2010-02-24 17:30:00	SPY	ETF	110.74	110.77	109.7965	110.74	456716.0
2010-02-24 18:00:00	SPY	ETF	110.75	110.8	110.71	110.75	67995.0
2010-02-24 18:30:00	SPY	ETF	110.73	110.76	110.71	110.74	5000.0
2010-02-24 19:00:00	SPY	ETF	110.73	110.78	110.72	110.74	34600.0
2010-02-24 19:30:00	SPY	ETF	110.77	110.8	110.73	110.79	72250.0
2010-02-24 04:00:00	QQQ	ETF	44.26	44.26	44.26	44.26	4000.0
2010-02-24 04:30:00	QQQ	ETF	44.28	44.28	44.28	44.28	4000.0
2010-02-24 05:00:00	QQQ	ETF	44.3	44.36	44.3	44.3	16100.0
2010-02-24 06:00:00	QQQ	ETF	44.32	44.32	44.32	44.32	2000.0
2010-02-24 06:30:00	QQQ	ETF	44.35	44.44	44.35	44.44	4300.0
2010-02-24 07:00:00	QQQ	ETF	44.43	44.45	44.42	44.43	185000.0
2010-02-24 07:30:00	QQQ	ETF	44.42	44.48	44.41	44.45	62224.0
2010-02-24 08:00:00	QQQ	ETF	44.45	44.46	44.43	44.44	342929.0
2010-02-24 08:30:00	QQQ	ETF	44.44	44.45	44.39	44.44	179635.0
2010-02-24 09:00:00	QQQ	ETF	44.44	44.44	44.38	44.39	482586.0
2010-02-24 09:30:00	QQQ	ETF	44.4099	44.65	44.39	44.59	11416168.0
2010-02-24 10:00:00	QQQ	ETF	44.58	44.62	44.32	44.43	13284479.0
2010-02-24 10:30:00	QQQ	ETF	44.42	44.79	44.39	44.7577	13849462.0
2010-02-24 11:00:00	QQQ	ETF	44.7	44.75	44.56	44.62	5680809.0
2010-02-24 11:30:00	QQQ	ETF	44.61	44.66	44.57	44.63	2557326.0
2010-02-24 12:00:00	QQQ	ETF	44.6325	44.71	44.59	44.65	2209978.0
2010-02-24 12:30:00	QQQ	ETF	44.6583	44.69	44.63	44.64	1493863.0
2010-02-24 13:00:00	QQQ	ETF	44.642	44.75	44.62	44.7	2519897.0

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

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