PREVIEW / etf_30min / 2008-05-14

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-05-14.parquet
  size:    163 KB
  rows:    5,730

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
2008-05-14 04:30:00	SPY	ETF	140.72	140.72	140.72	140.72	200.0
2008-05-14 06:00:00	SPY	ETF	140.4	140.4	140.24	140.25	120200.0
2008-05-14 06:30:00	SPY	ETF	140.25	140.44	140.25	140.4	7900.0
2008-05-14 07:00:00	SPY	ETF	140.41	140.41	139.99	140.11	252126.0
2008-05-14 07:30:00	SPY	ETF	140.19	140.34	140.17	140.33	300200.0
2008-05-14 08:00:00	SPY	ETF	140.35	140.43	140.25	140.38	1584881.0
2008-05-14 08:30:00	SPY	ETF	140.4	141.3	140.26	141.14	5677168.0
2008-05-14 09:00:00	SPY	ETF	141.12	141.18	141.05	141.09	988183.0
2008-05-14 09:30:00	SPY	ETF	141.09	142.0	141.01	141.49	26974148.0
2008-05-14 10:00:00	SPY	ETF	141.48	141.65	141.37	141.55	10734098.0
2008-05-14 10:30:00	SPY	ETF	141.55	141.82	141.49	141.62	15473521.0
2008-05-14 11:00:00	SPY	ETF	141.62	141.66	141.44	141.61	7197431.0
2008-05-14 11:30:00	SPY	ETF	141.6	141.8	141.58	141.67	5032832.0
2008-05-14 12:00:00	SPY	ETF	141.67	141.85	141.65	141.73	4141820.0
2008-05-14 12:30:00	SPY	ETF	141.72	141.78	141.59	141.75	5187546.0
2008-05-14 13:00:00	SPY	ETF	141.75	142.07	141.73	141.99	8093095.0
2008-05-14 13:30:00	SPY	ETF	141.98	142.2	141.98	142.05	7981379.0
2008-05-14 14:00:00	SPY	ETF	142.05	142.119	141.89	141.985	12041742.0
2008-05-14 14:30:00	SPY	ETF	141.99	142.15	141.81	141.83	9922731.0
2008-05-14 15:00:00	SPY	ETF	141.83	141.89	141.43	141.5	16302772.0
2008-05-14 15:30:00	SPY	ETF	141.4999	141.93	140.88	140.96	31636580.0
2008-05-14 16:00:00	SPY	ETF	141.01	141.5938	140.8	140.83	5919410.0
2008-05-14 16:30:00	SPY	ETF	140.85	141.77	140.64	140.74	1726719.0
2008-05-14 17:00:00	SPY	ETF	140.78	140.81	140.46	140.75	2365863.0
2008-05-14 17:30:00	SPY	ETF	140.73	140.83	140.68	140.81	9920.0
2008-05-14 18:00:00	SPY	ETF	140.78	140.87	140.78	140.86	15950.0
2008-05-14 18:30:00	SPY	ETF	140.88	140.88	140.81	140.86	20676.0
2008-05-14 19:00:00	SPY	ETF	140.86	140.88	140.83	140.83	5866.0
2008-05-14 19:30:00	SPY	ETF	140.83	140.83	140.81	140.81	1500.0
2008-05-14 04:30:00	QQQ	ETF	49.3	49.3	49.3	49.3	1000.0
2008-05-14 06:00:00	QQQ	ETF	49.16	49.16	49.15	49.15	3000.0
2008-05-14 07:00:00	QQQ	ETF	49.21	49.21	49.11	49.15	6700.0
2008-05-14 07:30:00	QQQ	ETF	49.16	49.18	49.16	49.18	17300.0
2008-05-14 08:00:00	QQQ	ETF	49.18	49.22	49.16	49.22	484236.0
2008-05-14 08:30:00	QQQ	ETF	49.22	49.51	49.22	49.46	2604852.0
2008-05-14 09:00:00	QQQ	ETF	49.46	49.48	49.41	49.41	457125.0
2008-05-14 09:30:00	QQQ	ETF	49.42	49.71	49.38	49.67	16759695.0
2008-05-14 10:00:00	QQQ	ETF	49.68	49.73	49.64	49.69	6845868.0
2008-05-14 10:30:00	QQQ	ETF	49.7	49.88	49.68	49.75	10701285.0
2008-05-14 11:00:00	QQQ	ETF	49.7504	49.77	49.6	49.69	6663521.0
2008-05-14 11:30:00	QQQ	ETF	49.69	49.76	49.65	49.69	3503481.0
2008-05-14 12:00:00	QQQ	ETF	49.69	49.79	49.68	49.72	2953903.0
2008-05-14 12:30:00	QQQ	ETF	49.71	49.72	49.62	49.7	3770725.0
2008-05-14 13:00:00	QQQ	ETF	49.69	49.85	49.69	49.8198	6252118.0
2008-05-14 13:30:00	QQQ	ETF	49.82	49.93	49.81	49.87	5925482.0
2008-05-14 14:00:00	QQQ	ETF	49.87	49.92	49.83	49.84	5010542.0
2008-05-14 14:30:00	QQQ	ETF	49.85	49.92	49.66	49.67	12955056.0
2008-05-14 15:00:00	QQQ	ETF	49.67	49.68	49.28	49.38	19036945.0
2008-05-14 15:30:00	QQQ	ETF	49.38	49.4	49.04	49.1	27133568.0
2008-05-14 16:00:00	QQQ	ETF	49.1	49.5745	49.03	49.07	2614769.0

> showing 50 of 5,730 rows — these rows as CSV

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