PREVIEW / etf_30min / 2010-07-27

all etf 30-min files

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

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-07-27 04:00:00	SPY	ETF	111.58	111.93	111.58	111.93	1946.0
2010-07-27 04:30:00	SPY	ETF	111.92	111.92	111.82	111.82	624.0
2010-07-27 05:00:00	SPY	ETF	111.78	111.8	111.78	111.8	200.0
2010-07-27 05:30:00	SPY	ETF	111.84	111.92	111.83	111.92	3390.0
2010-07-27 06:00:00	SPY	ETF	111.91	112.05	111.91	112.01	11100.0
2010-07-27 06:30:00	SPY	ETF	111.99	112.03	111.95	112.02	52395.0
2010-07-27 07:00:00	SPY	ETF	112.03	112.12	112.03	112.08	249045.0
2010-07-27 07:30:00	SPY	ETF	112.12	112.16	111.94	112.14	464781.0
2010-07-27 08:00:00	SPY	ETF	112.15	112.15	111.98	112.15	946140.0
2010-07-27 08:30:00	SPY	ETF	112.15	112.2	112.08	112.14	666804.0
2010-07-27 09:00:00	SPY	ETF	112.14	112.37	107.3588	112.17	1939605.0
2010-07-27 09:30:00	SPY	ETF	112.17	112.29	111.75	111.77	28373772.0
2010-07-27 10:00:00	SPY	ETF	111.76	112.29	111.46	111.81	34391339.0
2010-07-27 10:30:00	SPY	ETF	111.82	111.87	111.5	111.58	13064707.0
2010-07-27 11:00:00	SPY	ETF	111.59	111.62	111.11	111.32	17866497.0
2010-07-27 11:30:00	SPY	ETF	111.32	111.53	111.29	111.525	11081292.0
2010-07-27 12:00:00	SPY	ETF	111.53	111.7899	111.45	111.72	8937479.0
2010-07-27 12:30:00	SPY	ETF	111.72	111.74	111.415	111.46	8562005.0
2010-07-27 13:00:00	SPY	ETF	111.46	111.57	111.26	111.27	7811998.0
2010-07-27 13:30:00	SPY	ETF	111.28	111.63	111.22	111.49	9890606.0
2010-07-27 14:00:00	SPY	ETF	111.48	111.78	111.41	111.62	9802217.0
2010-07-27 14:30:00	SPY	ETF	111.63	111.69	111.3	111.44	8388546.0
2010-07-27 15:00:00	SPY	ETF	111.44	111.81	111.43	111.78	12386516.0
2010-07-27 15:30:00	SPY	ETF	111.79	111.805	111.43	111.52	16942220.0
2010-07-27 16:00:00	SPY	ETF	111.5	112.155	111.315	111.6	9385827.0
2010-07-27 16:30:00	SPY	ETF	111.58	111.61	111.55	111.57	667953.0
2010-07-27 17:00:00	SPY	ETF	111.57	111.6	111.53	111.55	93435.0
2010-07-27 17:30:00	SPY	ETF	111.54	111.57	111.54	111.55	1900.0
2010-07-27 18:00:00	SPY	ETF	111.55	111.57	111.51	111.53	63081.0
2010-07-27 18:30:00	SPY	ETF	111.53	111.57	111.52	111.53	3023.0
2010-07-27 19:00:00	SPY	ETF	111.54	111.57	111.53	111.57	6450.0
2010-07-27 19:30:00	SPY	ETF	111.57	111.58	111.54	111.55	18020.0
2010-07-27 04:00:00	QQQ	ETF	46.47	46.62	46.47	46.62	617.0
2010-07-27 05:30:00	QQQ	ETF	46.61	46.61	46.59	46.59	50300.0
2010-07-27 06:00:00	QQQ	ETF	46.6	46.67	46.6	46.67	2300.0
2010-07-27 06:30:00	QQQ	ETF	46.68	46.68	46.68	46.68	2500.0
2010-07-27 07:00:00	QQQ	ETF	46.67	46.7	46.66	46.66	35886.0
2010-07-27 07:30:00	QQQ	ETF	46.68	46.69	46.6	46.68	84278.0
2010-07-27 08:00:00	QQQ	ETF	46.68	46.69	46.63	46.67	141856.0
2010-07-27 08:30:00	QQQ	ETF	46.67	46.73	46.44	46.7	278199.0
2010-07-27 09:00:00	QQQ	ETF	46.71	46.77	46.64	46.69	303318.0
2010-07-27 09:30:00	QQQ	ETF	46.69	46.72	46.51	46.51	9290891.0
2010-07-27 10:00:00	QQQ	ETF	46.51	46.71	46.36	46.54	9514858.0
2010-07-27 10:30:00	QQQ	ETF	46.54	46.56	46.35	46.39	4845959.0
2010-07-27 11:00:00	QQQ	ETF	46.39	46.4	46.21	46.32	4166674.0
2010-07-27 11:30:00	QQQ	ETF	46.32	46.4	46.31	46.3701	2015938.0
2010-07-27 12:00:00	QQQ	ETF	46.38	46.49	46.35	46.43	2628995.0
2010-07-27 12:30:00	QQQ	ETF	46.43	46.47	46.29	46.34	3876838.0
2010-07-27 13:00:00	QQQ	ETF	46.35	46.36	46.22	46.23	1712579.0
2010-07-27 13:30:00	QQQ	ETF	46.23	46.4	46.21	46.35	4020863.0

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

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